Top 10 Reserved SQL Keywords

databases You may know that I created a SQL Reserved Keywords Checker a few years ago. I was just noticing today that a lot of people are searching for the same keywords. Here's a list of the top 10 keywords people searched for using the tool in the past year:.


This entry was:

INFORMATION_SCHEMA Support in MySQL, PostgreSQL

databases I've known about the INFORMATION_SCHEMA views (or system tables) in SQL Server for a while, but I just leared recently that they are actually part of the SQL-92 standard and supported on other database platforms.


This entry was:

EnterpriseDB - PostgreSQL with Oracle Compatibility

databases I have been hearing a bit of buzz about EnterpriseDB latley. I think the main reason is that they just secured $7 million in venture capital funding.

What is EnterpriseDB?

EnterpriseDB is based on the source code for the open source PostgreSQL database server.


This entry was:

SQL to Select a random row from a database table

databases There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don't require additional application logic, but each database server requires different SQL syntax.


This entry was:

Cheat Sheet for PostgreSQL

databases When I created my list of cheat sheets for web development last week, I left out PostgreSQL. Frank Reiser, asked why it was left out - and the reason was simply that I couldn't find one.

Being a PostgreSQL fan, I decided to create a cheat sheet for postgresql myself.


This entry was:

Faster Inserts with PostgreSQL

databases As I mentioned yesterday, I'm working on optimizing lots of inserts into a database, and I need solutions for different DB servers. Today I have been working with PostgreSQL. Although the PostgreSQL COPY command is recommended, I can't seam to get it to work with ColdFusion, and cfquery.


This entry was:

LIMIT and OFFSET SQL Pagination

databases Both MySQL and PostgreSQL support a really cool feature called OFFSET that is usually used with a LIMIT clause.

The LIMIT clause is used to limit the number of results returned in a SQL statement.


This entry was:

SQL Reserved Key Words Checker Tool

databases I just whipped together a tool for checking for reserved sql words. The tool checks against SQL Server 2000, MySQL 5.0, PostgreSQL 8.0, Oracle 10g, ODBC, and SQL Server Future Keywords list.


This entry was:

PostgreSQL for Mac OS X

apple databases There is a new project that has created an installer for PostgreSQL Database Server on Mac OS X. The project also aims to create some native OSX gui tools for PostgreSQL.


This entry was:

Top 3 differences between PostgreSQL and MS SQL

databases I recently switched a database server from Microsoft SQL Server over to PostgreSQL.


This entry was:

Returning TOP N Records

databases Returning only the first N records in a SQL query differs quite a bit between database platforms.


This entry was:

foundeo


did you hack my cf?