Blog Archives

SQLite Tool-set

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)

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

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

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

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