Search Results for: sqlite

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

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

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

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

SQL: One of the most valuable skills – Craig Kerstiens

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

Oracle Auto increment trigger HOWTO

Oracle SQL Developer is full of nice feature, damned by a overwhelming options pane, like the one I will describe to you right now. Even if  Oracle databases (<12) does not support auto increment, you can easily ask to your … Continue reading

Posted in English Content, IT Featured, Knowledgebase, Structured Query Language (SQL) | Tagged , , , , | Comments Off on Oracle Auto increment trigger HOWTO