Search Results for: sqlite

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)

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 →

Posted in Italian Content, Structured Query Language (SQL) | Tagged , , , , , , | Comments Off on SQLite alter table

Web2Py Absolute trouble Shooter

Posted on March 4, 2010 by Giovanni Giorgi

Do you want develop web applications in a fast, prototype based way using Python? Follow us and learn how to use web2py…. Step 1: Python 2.6 proper setup On Linux be sure to install sqlite development library; the following command … Continue reading →

Posted in English Content, Knowledgebase | Tagged , , | Comments Off on Web2Py Absolute trouble Shooter

Bug Tracking Tools 3: Trac

Posted on November 27, 2008 by Giovanni Giorgi

Trac is a quite famous bug tracking software written in python. It is considered very strong its subversion integration Pros: Can Also work with an embedded database (using sqlite). Easy to setup and use. Cons: Feature are too much, and … Continue reading →

Posted in English Content, Knowledgebase, Software | Tagged , | Comments Off on Bug Tracking Tools 3: Trac

Exploring a 23 years old code base: LambdaMoo MUD Part 1

Posted on April 5, 2018 by Giovanni Giorgi

On these days my greek daemon (the one which talk to me about deep nerd programming) was interested on LambdaMoo. LambdaMoo is an Object Oriented Multi User Dungeon born back in 1995. A MUD was a text based system you … Continue reading →

Posted in English Content, IT Featured, Software | Tagged | Comments Off on Exploring a 23 years old code base: LambdaMoo MUD Part 1

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

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