Oracle |

Smart Sync

Mar 21, 2021 · 1 min read

en software-projects · database oracle sqlite

·

Share on:

On 2002, I was forced to build a small java class to “sync” two databases (sorry for Italian):

Semplice metodo per storicizzare i dati su database

Mar 16, 2021 · 6 min read

it sql · database oracle

·

Share on:

Abstract: Storicizzare i dati spesso è un attività considerata “secondaria”, ma un cattivo design porta a base dati difficili da ottimizzare e spesso poco comprensibili. In questo articolo illustriamo un semplice metodo che rispetta i dettami della teoria relazionale, è facile da capire ed è attivamente usato in produzione.

SQLite Oracle Compatibility Layer

Aug 7, 2018 · 1 min read

en projects python software-projects sql · oracle sql sqlite

·

Share on:

The Sqlite Oracle Compatibility Functions is an experimental compatibility layer for SQLite vs Oracle, written in Python 3.

Removing duplicate rows in PostgreSQL, Oracle and SQLite

Jun 15, 2017 · 1 min read

en knowledgebase sql · evil oracle postgresql sql

·

Share on:

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 is called ctid, as we shall see:

Italian Accent Oracle fix

Feb 10, 2017 · 1 min read

en sql · oracle relax

·

Share on:

In Italian language we have accent words like àèéìòù