open-menu closeme
Home
RetroComp icon
Retro Computing Articles Composition Notebooks 8bit
DevOps icon
Automation K8s Done Right
GenAI icon
Fatlama Newsletter Generative AI
Projects icon
Software Projects Arduino Esp8266 SQLite
Status
Links icon
GitHub LinkedIn
About
🌐
English Italiano
github linkedin rss
  • BWolf first installation

    calendar Jul 5, 2006 · 1 min read
     blog-objectsrootcom en  · ant book database db developement django embedded file framework future link links python script sql sqlite subversion table test ui vi web
     ·
    Share on: twitter facebook linkedin copy
    BWolf first installation

    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
  • Biblio Wolf first install

    calendar Jul 12, 2006 · 1 min read
     blog-objectsrootcom en  · link postgresql sql sqlite
     ·
    Share on: twitter facebook linkedin copy
    Biblio Wolf first install

    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 alter table

    calendar Jul 25, 2010 · 1 min read
     it sql  · cute embedded programming small smart sql sqlite
     ·
    Share on: twitter facebook linkedin copy

    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
  • Help Daitan find a Sql solution for codezauker

    calendar Mar 6, 2012 · 3 min read
     en featured software sql  · nosql redis sqlite
     ·
    Share on: twitter facebook linkedin copy
    Help Daitan find a Sql solution for codezauker

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

    calendar Aug 7, 2018 · 1 min read
     en projects python software-projects sql  · oracle sql sqlite
     ·
    Share on: twitter facebook linkedin copy

    The Sqlite Oracle Compatibility Functions is an experimental compatibility layer for SQLite vs Oracle, written in Python 3.


    Read More
  • SQL: One of the most valuable skills - Craig Kerstiens

    calendar Feb 19, 2019 · 2 min read
     en sql  · postgresql sql sqlite
     ·
    Share on: twitter facebook linkedin copy

    I admit it. I suffered from an “algebra narcoleptic syndrome” during my relational database lessons at University (1996 circa).


    Read More
  • Smart Sync

    calendar Mar 21, 2021 · 1 min read
     en software-projects  · database oracle sqlite
     ·
    Share on: twitter facebook linkedin copy

    On 2002, I was forced to build a small java class to “sync” two databases (sorry for Italian):


    Read More
  • Simple method to add historic feature to SQLite

    calendar Apr 8, 2021 · 5 min read
     en featured knowledgebase sql  · database sqlite
     ·
    Share on: twitter facebook linkedin copy
    Simple method to add historic feature to SQLite

    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
  • Evil Open Source

    calendar May 27, 2021 · 2 min read
     en  · eclipse k8s sqlite
     ·
    Share on: twitter facebook linkedin copy

    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, again (updated)

    calendar Jun 21, 2021 · 2 min read
     en  · sql sqlite
     ·
    Share on: twitter facebook linkedin copy

    SQLite is slowing becoming a new standard. It is fast, and has a growing number of features.


    Read More
    • ««
    • «
    • 1
    • 2
    • »
    • »»

Giovanni Giorgi

Master Solution Architect, father and free spirit.
Read More

Recent Posts

  • Interludio sul value investing
  • Anubis: DDos Protection
  • KarmaKit and Watchtower
  • FatLama for GenAI: The comeback!

Latest comments

    Disclaimer

    Gioorgi is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for website owners to earn advertising fees by advertising and linking to amazon.com, audible.com, and any other website that may be affiliated with Amazon Service LLC Associates Program. As an Amazon Associate we earn from qualifying purchases.
    Last updated:2025-05-27 02:00
    Giovanni Giorgi

    Copyright 1999-  GIOVANNI GIORGI. All Rights Reserved

    to-top