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 Misterio Esp8266 SQLite
Status
Links icon
GitHub LinkedIn
About
github linkedin rss
  • 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
  • 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
  • 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 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
  • 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
    • ««
    • «
    • 1
    • 2
    • 3
    • »
    • »»

Recent Posts

  • Misterio Is Back
  • Netflix retro weird spirit
  • Yakuza Blues
  • FreeBSD on MacBook Mid 2009 with BroadCom WIFI

Latest comments

    Giovanni Giorgi

    Copyright 1999-  GIOVANNI GIORGI. All Rights Reserved

    to-top