Search Results for: sqlite

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

Posted in Uncategorized | Leave a comment

BWolf first installation

Introducing first steps in Biblio Wolf Continue reading

Posted in English Content, Legacy ObjectsRoot.com | Tagged , , , , , , , , , , , , , , , , , , , , , , , | Comments Off on BWolf first installation

Biblio Wolf first install

Biblio wolf has been installed in a production environment. Continue reading

Posted in English Content, Legacy ObjectsRoot.com | Tagged , , , | Comments Off on Biblio Wolf first install

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

In this second article I will continue my jorney on LambdaMoo code base. The C code is very well written. Sometimes the API abuse global variable to avoid passing around identifier like output database file descriptor or the like. Because … Continue reading

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

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 Oracle Compatibility Layer

  It aims to provide a minimal compatibility with Oracle. The need was having some regular expression functions, and I do not like to work with risky C code, like this university project did Github link: https://gitlab.com/daitangio/sqlite_ora_functions

Posted in English Content, Gio's Software Projects, Projects, Python, Structured Query Language (SQL) | Tagged , , | Comments Off on SQLite Oracle Compatibility Layer

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