-
Biblio Wolf (Bwolf for firends) is a webapp app for managing a book collection. BWolf is written in python using the Django web framework, and it is born from a Customer request. BWolf is open source, and you can get a full description here including links to downloads. I will mantain a blog of all the work I will do. In the last two months I set up a Subversion Repository and played a little with Django.
Read More -
The installation was fine. I have some problems with the sqlite3 driver and I ought to switch back to the PostreSQL driver. I initially planned sqlite3 as deployment platform.I have to change my mind after losing over three hours trying to resolve a linking problems on the production machine. By the way with PostgreSQL I will have more powerful exporting capabilities
Read More -
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 a big sqllite db
- DropBox client, to store its internal state
- iPhone: stores your SMS and also other stuff. It is widely used by apps.
- Apple Safari uses it for HTML5 storage support
- Google Gears uses it
- ...and in a lot of embedded product.
I was annoyed because until version 3.1.3 SQLite did not provide an alter table syntax but… it is quite easy to emulate it with something like this, even if it required a bit of work:
Read More -
In my code ramblings during the developement of Code Zauker, I ended up studing a bit NoSql database.
Code zauker started using Redis, because Redis is a very bold memory-based no-sql db. Redis also support complex data type like sorted set, lists and so on, which was very userful. Anyway I needed a very fast way of doing statistics on data collected by code zauker, for inspecting data and finding out new feature I’d like to add to it. Worst, my current pocket pose a hard limit on a redis instance in terms of available RAM. So I started thinking a lot about a redis drop-in replacement for Code Zauker.
Read More -
The Sqlite Oracle Compatibility Functions is an experimental compatibility layer for SQLite vs Oracle, written in Python 3.
Read More -
I admit it. I suffered from an “algebra narcoleptic syndrome” during my relational database lessons at University (1996 circa).
Read More -
Abstract: Make a database which can be store historic modification is often considered a “secondary” activity, but bad design leads to databases that are difficult to optimize and often not very understandable. In this article we illustrate a simple method that respects the dictates of relational theory & is easy to understand. As a plus we will show it on SQLite, a small but powerful database system.
Read More -
In my personal top ten on open source software initiative with some original sin inside them. Note: this is not a negative review, is only a snapshot of the world I see, I could be wrong, but please explain to me my mistakes, if any.
Read More -
SQLite is slowing becoming a new standard. It is fast, and has a growing number of features.
Read More