Postgresql |

Biblio Wolf first install

Jul 12, 2006 · 1 min read en blog-objectsrootcom · link postgresql sql sqlite ·

The installation was fine. I have some problems with the sqlite3 driver and I ought to switch back to the PostreSQL driver. I initially planned sqlite3 as deployment platform.I have to change my mind after losing over three hours trying to resolve a linking problems on the production machine. By the way with PostgreSQL I will have more powerful exporting capabilities

oracle mass table drop

Jul 3, 2007 · 1 min read en blog-objectsrootcom · build easy oracle postgresql script small sql table ui vi ·

Share on:

Sometimes I need to build a small script to delete a huge set of tables of a schema.

Postgres performance tuning

Apr 3, 2008 · 1 min read en knowledgebase blog-objectsrootcom software sql · database postgresql sql ·

Share on:

After a bit of work, I have managed to optimize the performance of my Postgresql Server.

Removing duplicate rows in PostgreSQL, Oracle and SQLite

Jun 15, 2017 · 1 min read en knowledgebase sql · evil oracle postgresql sql ·

Share on:

Sometimes you need to remove nasty duplicate on a table, based on a subset of the column. On every big database there is something called "rowid" which can be used to indentify a column in a unique way. On PostgreSQL is called ctid, as we shall see:

SQL: One of the most valuable skills - Craig Kerstiens

Feb 19, 2019 · 2 min read en sql · postgresql sql sqlite ·

Share on:

I admit it. I suffered from an "algebra narcoleptic syndrome" during my relational database lessons at University (1996 circa).