Search Results for: sqlite

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

Posted in English Content | Tagged , | Comments Off on SQLite, again (updated)

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

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

Web2Py Absolute trouble Shooter

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

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

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

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

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