Live from TSSJS – PostgreSQL with Tom

Main menu:

Topics

Recent Posts

Feeds

RSS Feed RSS - Posts

September 2017
M T W T F S S
« Aug    
 123
45678910
11121314151617
18192021222324
252627282930  

Past Posts

Java/Java EE

JDBC

Other

Archive for category JDBC

Live from TSSJS – PostgreSQL with Tom

March 17th, 2011 by Scott Selikoff

Live blogging from TheServerSide Java Symposium with Tom Kincaid at his vendor presentation “Introduction to PostgreSQL for Development and Deployment”.  Tom spends a lot of time contrasing Postgres with MySQL, and commenting how since Oracle’s aquisition of MySQL, the licensing of MySQL is now much more restrictive. Tom says the licensing of Postgres is basically “Do […]

Memo: Avoid Functions in Database Queries

October 21st, 2010 by Scott Selikoff

The most common type of questions in the JavaRanch JDBC forum tends to be about improving performance in a database (that, and “Where can I download a JDBC Driver?”). While remote trouble-shooting performance issues can be tricky, we often spot issues with the presented queries and offer alternatives to improve performance. One issue I see […]

postgresql and jdbc

June 13th, 2010 by Jeanne Boyarsky

In postgresql – selecting maximum for each group, we saw the actual stored function.  That was the easy part.  Then there was dealing with Postgresql and JDBC.  I encountered a few surprises while doing this. Calling the stored function I expected to use JDBC’s CallableStatement since I was calling a stored procedure.  Nope.  The proper […]