Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Postgres. . .the other white meat

 
Andrew Shafer
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Does anybody have any experience working with PostgreSQL?
The "other" open source DB. . .
 
rani bedi
Ranch Hand
Posts: 358
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have worked with PostgreSQL.
The first problem I ran into was that Postgres has an arcane limit of 8k of data per row. The other - its "serial" data type (the equivalent of MySQL's auto_increment) creates a "sequence" which does not get dropped when its parent table is dropped. So if you try to re-create the table, you'll get a name conflict for this sequence. A lot of new users would be confused by this, so Postgres loses a couple points for that.Postgres' sequence (auto_increment value) does not get reset when you import data, causing all new inserts to fail.
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Some of the traditional limitations of PostgresSQL are not really there any more. I was intrigued by this article I read recently which compares it surprisingly favourably with mySQL.
 
Andrew Shafer
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Parmeet,
What version were you using? How long ago?
I'm just curious
 
Mark Leong
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I managed to get Postgresql installed and running on my RedHat6.2 machine. I want to connect to it using servlets from my Win98 machine running Tomcat. What I have done is to place a copy of the jdbc6.5-1.2.jar file in the Win98 machine and set the classpath to point to it. Start the servlet to make the connection.
However I got a SQL exception message from Tomcat saying:-
can't find class for driver: org.postgresql.Driver.....
I am very sure the classpath was set correctly. I got the same message when I tried to connect to the database in the RedHat6.2 machine (also using servlet and running Tomcat).
Any pointers?
 
Mark Leong
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Just to add...
I have actually managed to connect to Postgresql a couple of months back using the same technique described above.
I have not touched it for a couple of months and somehow it does not work now.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic