Search Results for: sqlite

Come funzionava il TURBOTAPE di C/64 e Vic20?

In modo molto complicato…. ora ci arriviamo I Computer Commodore erano venduti senza alcuna periferica. Quella che costava meno, era il registratore  a cassette, che era un dispositivo “custom”. Contrariamente allo ZX Spectrum, non era infatti possibile collegare un registratore … Continue reading

Posted in Italian Content, Lettere a mia figlia, Retro Computing | Tagged , | Leave a comment

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 IT Featured, Knowledgebase, Structured Query Language (SQL) | Leave a comment

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

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

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, 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)