Tag Archives: sqlite

I big data sono passati di moda?

Posted on February 10, 2023 by Giovanni Giorgi
Questo articolo, di tal Jordan Tigani, getta una luce oscura sul futuro dei big data. E’ scritto dal CEO di un’azienda che sviluppa un nuovo database OLAP (Online analytical processing) chiamato Duckdb, che e’ open source ed e’ “embedded”, nel … Continue reading →
Posted in Italian Content, Lettere a mia figlia | Tagged , , , , | Leave a comment

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)

Evil Open Source

Posted on May 27, 2021 by Giovanni Giorgi
In my personal top ten on open source software initiative with some original sin inside them. Note: this is not a negative review, is only a snapshot of the world I see, I could be wrong, but please explain to … Continue reading →
Posted in English Content | Tagged , , , , | Comments Off on Evil Open Source

Simple method to add historic feature to SQLite

Posted on April 9, 2021 by Giovanni Giorgi
Abstract: Make a database which can be store historic modification is often considered a “secondary” activity, but bad design leads to databases that are difficult to optimize and often not very understandable. In this article we illustrate a simple method … Continue reading →
Posted in English Content, IT Featured, Knowledgebase, Structured Query Language (SQL) | Tagged , | Comments Off on Simple method to add historic feature to SQLite

Smart Sync

Posted on March 22, 2021 by Giovanni Giorgi
On 2002, I was forced to build a small java class to “sync” two databases (sorry for Italian): SmartSync used the Metadata offered by JDBC API to be able to copy data between two tables. In the last years I … Continue reading →
Posted in English Content, Gio's Software Projects | Tagged , , , | Comments Off on Smart Sync

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

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