Search
Translate / Traduci
-
Available even in U.S.A. Support Gioorgi Editorial Board
Facet
Gioorgi EverGreen
Tag Archives: postgresql
SQL: One of the most valuable skills – Craig Kerstiens
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 it seems so real on these days. I was unable to avoid sleeping. I learned … Continue reading
Posted in English Content, Structured Query Language (SQL)
Tagged postgresql, skill, sql, sqlite
Comments Off on SQL: One of the most valuable skills – Craig Kerstiens
Removing duplicate rows in PostgreSQL, Oracle and SQLite
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 … Continue reading
Posted in English Content, Knowledgebase, Structured Query Language (SQL)
Tagged dup, duplicate, duplicates, evil, oracle, postgresql, removal, sql
Comments Off on Removing duplicate rows in PostgreSQL, Oracle and SQLite
Postgres performance tuning
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 fantastic komodo editor, and I am happy with the final solution. I followed … Continue reading
Posted in English Content, Knowledgebase, Legacy ObjectsRoot.com, Software, Structured Query Language (SQL)
Tagged database, postgresql, sql
Comments Off on Postgres performance tuning
Biblio Wolf first install
Biblio wolf has been installed in a production environment. Continue reading
Posted in English Content, Legacy ObjectsRoot.com
Tagged link, postgresql, sql, sqlite
Comments Off on Biblio Wolf first install