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 …
Read More

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.

In Oracle is easy to do it, using the meta tables "all_tables", …

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.

I have spent a saturday morning digging around postgresql, using the …

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" …
Read More

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).

Ok it is a fake. But …