Search
Translate / Traduci
-
Available even in U.S.A. Support Gioorgi Editorial Board
Facet
Gioorgi EverGreen
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
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 python, web, web2py
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 bugtracking, development
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 lambdamoo
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 database, mssqlserver, oracle, sqlite
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 dup, duplicate, duplicates, evil, oracle, postgresql, removal, sql
Comments Off on Removing duplicate rows in PostgreSQL, Oracle and SQLite