Tag Archives: sql

SQLite, again (updated)

Posted on June 22, 2021 by Giovanni Giorgi
SQLite is slowing becoming a new standard. It is fast, and has a growing number of features. Useful settings PRAGMA journal_mode = wal; PRAGMA foreign_keys = true; Query, set, or clear the enforcement of foreign key constraints. PRAGMA busy_timeout=….; In milliseconds, … Continue reading →
Posted in English Content | Tagged , | Comments Off on SQLite, again (updated)

SQL: One of the most valuable skills – Craig Kerstiens

Posted on February 20, 2019 by Giovanni Giorgi
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 , , , | Comments Off on SQL: One of the most valuable skills – Craig Kerstiens

Outer full and inner SQL joins: you are wellcome

Posted on August 27, 2018 by Giovanni Giorgi
For a complete description see https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
Posted in English Content, Structured Query Language (SQL) | Tagged | Comments Off on Outer full and inner SQL joins: you are wellcome

SQLite Oracle Compatibility Layer

Posted on August 7, 2018 by Giovanni Giorgi
  It aims to provide a minimal compatibility with Oracle. The need was having some regular expression functions, and I do not like to work with risky C code, like this university project did Github link: https://gitlab.com/daitangio/sqlite_ora_functions
Posted in English Content, Gio's Software Projects, Projects, Python, Structured Query Language (SQL) | Tagged , , | Comments Off on SQLite Oracle Compatibility Layer

Removing duplicate rows in PostgreSQL, Oracle and SQLite

Posted on June 16, 2017 by Giovanni Giorgi
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 , , , , , , , | Comments Off on Removing duplicate rows in PostgreSQL, Oracle and SQLite

Oracle SQL Developer Keep Alive plugin

Posted on January 26, 2017 by Giovanni Giorgi
On some environment, on some customers, Oracle connections are drop after some idle time (i.e. 2 minutes). I have found a small plugin for Sql Developer to solve this issue: it is very handy and logs its usage. Code is also … Continue reading →
Posted in English Content, Gio's Software Projects, Knowledgebase, Software, Structured Query Language (SQL) | Tagged , , , | Comments Off on Oracle SQL Developer Keep Alive plugin

ORA-01461: can bind a LONG value only for insert into a LONG column

Posted on September 2, 2015 by Giovanni Giorgi
Okey, you know Oracle. A very good database, a very old database, a very solid rock. Not famous for its error messages. I have already stumbled upon a misleading error on the old rock. This error anyway is incredible. If you … Continue reading →
Posted in English Content, Knowledgebase | Tagged , , , | Comments Off on ORA-01461: can bind a LONG value only for insert into a LONG column