SQL

  • submit to reddit

MySQL Limitations Part 1: Single-Threaded Replication

I recently mentioned a few of the big “non-starter” limitations Postgres has overcome for specific use cases. I decided to write a series of blog...

0 replies - 7085 views - 11/15/10 by Peter Zaitsev in News

Daily Dose - Google Fires Back: 'Oracle Doctored the Code in Question'

Google presented a new document to the court in the Oracle-Android case.  In the document, Google says that they did not copy Oracle's Java APIs and that...

0 replies - 25623 views - 11/13/10 by Mitch Pronschinske in Daily Dose

10 things in MySQL that won’t work as expected

#10. Searching for a NULL SELECT *FROM aWHERE a.column = NULL In SQL, a NULL is never equal to anything, even another NULL. This query won’t return...

3 replies - 11936 views - 11/12/10 by Alex Bolenok in News

SQL Can Be Slow -- Why Do People Doubt This?

Here's a typical problem that results from "SQL Hegemony" -- all data must be in a database, and all access must be via SQL. This can also be ...

12 replies - 8176 views - 10/01/10 by Steven Lott in News

MySQL Fork "Drizzle" Shows Signs of Life

While other Sun projects such as OpenSolaris and OpenOffice.org were driven to make forks (Illumos and LibreOffice respectively) under Oracle's new leadership...

0 replies - 6700 views - 09/30/10 by Mitch Pronschinske in Articles

Playing with a DBMonster

I recently had the privilege of using DBMonster (http://dbmonster.kernelpanic.pl) when I needed to generate some random test data for a MySQL database....

0 replies - 8663 views - 09/27/10 by Adedayo Ominiyi in Tips and Tricks

Daily Dose - RC1 of MySQL 5.5 Adds InnoDB Default

The nearly finished 5.5 version of MySQL is at the release candidate stage this week.   The 5.5 version now uses InnoDB by default instead of the old...

0 replies - 17537 views - 09/21/10 by Mitch Pronschinske in Daily Dose

Daily Dose - PostgreSQL 9 Released Ahead of Announcement

Before the official announcement went out, the final version of PostgreSQL was released this weekend.  If you browsed the PostgreSQL FTP server you could find...

0 replies - 20070 views - 09/19/10 by Mitch Pronschinske in Daily Dose

PostgreSQL 9.1 Alpha Arrives Ahead of 9.0 GA

With PostgreSQL 9.0 approaching its final release, work on the next incremental version has already begun.  Today, PostgreSQL project developers released the...

0 replies - 7823 views - 09/08/10 by Mitch Pronschinske in News

Daily Dose - Release Candidate for PostgreSQL 9.0

After four months in beta, the first release candidate of the open source database, PostgreSQL, is ready for download.  PostgreSQL 9.0 includes some awesome...

0 replies - 21754 views - 09/01/10 by Mitch Pronschinske in Daily Dose

How To: Configuration Instructions for Activiti-5.0.alpha4 to Work With MySQL 5.1.49

The following tutorial will help you configure activiti-5.0.alpha4 to work with MySQL 5.x, and let you have a correct setup configuration and a startup...

0 replies - 5040 views - 08/27/10 by Manuel Jordan in Articles

Oracle Pulls the Rug Out From Under PostgreSQL

Before the Oracle acquisition, Sun was contributing three servers to the build farm for the PostgreSQL project to test updates and ensure stability on...

12 replies - 16731 views - 07/29/10 by Mitch Pronschinske in News

IntelliJ IDEA X Early Release - Major Spring, Groovy, and Maven Upgrades

The release of IntelliJ IDEA 9.0 last year brought a flurry of extra excitement with JetBrains' announcement that there would also be a FOSS Community Edition...

1 replies - 16409 views - 07/29/10 by Mitch Pronschinske in News

NoSQL -- Old Wine, New Bottle

Got an email with links about NoSQL. Links like "Going NoSQL with MongoDB". This -- like many such articles -- includes the phrase "the...

5 replies - 7362 views - 07/28/10 by Steven Lott in News

SQLite Gets Write-Ahead Logs

There's reason to celebrate today as SQLite 3.7 is released in GA.  The lightweight, ubiquitous database includes some game-changing new features, which have...

0 replies - 7527 views - 07/21/10 by Mitch Pronschinske in Articles