Blog Archives

SQLite Tool-set

Posted on June 20, 2022 by Giovanni Giorgi
Random list of very interesting projects (will be updated, guys). I will add my own ideas/impression as soon as possible. From simpler to more complex stuff: sqlite-utils is a rather useful tool for managing SQLite databases, importing structured data and … Continue reading →
This entry is part 5 of 5 in the series SQLite
Posted in Uncategorized | 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 →
This entry is part 1 of 5 in the series SQLite
Posted in English Content | Tagged , | Comments Off on SQLite, again (updated)

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 →
This entry is part 2 of 5 in the series SQLite
Posted in English Content, IT Featured, Knowledgebase, Structured Query Language (SQL) | Tagged , | Comments Off on Simple method to add historic feature to SQLite

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 →
This entry is part 3 of 5 in the series SQLite
Posted in English Content, Knowledgebase, Structured Query Language (SQL) | Tagged , , , , , , , | Comments Off on Removing duplicate rows in PostgreSQL, Oracle and SQLite

SQLite alter table

Posted on July 26, 2010 by Giovanni Giorgi
SQLite is a small, powerful embedded database. A friend of mine started using it about six years ago. Some years ago it comes also on top of  Python 2.5. It is used inside FileMaker Bento: its ultra customized model is based on … Continue reading →
This entry is part 4 of 5 in the series SQLite
Posted in Italian Content, Structured Query Language (SQL) | Tagged , , , , , , | Comments Off on SQLite alter table