Sqlite |

I big data sono passati di moda?

Feb 10, 2023 · 4 min read

it lettere-a-mia-figlia · nosql sql sqlite

·

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.

SQLite, again (updated)

Jun 21, 2021 · 2 min read

en · sql sqlite

·

Share on:

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

Evil Open Source

May 27, 2021 · 2 min read

en · eclipse k8s sqlite

·

Share on:

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.

Simple method to add historic feature to SQLite

Apr 8, 2021 · 5 min read

en featured knowledgebase sql · database sqlite

·

Share on:

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.

Smart Sync

Mar 21, 2021 · 1 min read

en software-projects · database oracle sqlite

·

Share on:

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