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
  • I big data sono passati di moda?

    calendar Feb 10, 2023 · 4 min read
     it lettere-a-mia-figlia  · nosql sql sqlite
     ·
    Share on: twitter facebook linkedin copy

    Questo articolo, di tal Jordan Tigani, getta una luce oscura sul futuro dei big data. E’ scritto dal CEO di un’azienda che sviluppa un nuovo database OLAP (Online analytical processing) chiamato Duckdb, che e’ open source ed e’ “embedded”, nel senso che si ispira molto al modo di funzionare di SQLite. L’articolo sottolinea come uno degli argomenti piu’ forti dietro la commercializzazione di sistemi BigData (come BigQuery, MongoDB ecc) e cioe’ l’enorme flusso di dati che avrebbe investito alcune aziende, rappresentando sia una opportunita’ che una sfida, non si e’ verificato nonostante queste profezie siano vecchie di dieci anni.


    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
  • 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
  • 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
  • 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
  • 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
    • »
    • »»

Recent Posts

  • 6,76%
  • Il tizio con il cappello che crede di comandare il mondo intero
  • Murderbot: i diari della macchina assassina
  • Breve guida agli ETF

Latest comments

    Giovanni Giorgi

    Copyright 1999-  GIOVANNI GIORGI. All Rights Reserved

    to-top