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
  • NoSQL Rocks? We try to understand

    calendar Apr 10, 2011 · 4 min read
     en featured knowledgebase sql  · ideas nosql sql
     ·
    Share on: twitter facebook linkedin copy
    NoSQL Rocks? We try to understand

    At Gioorgi.com we was never a SQL fan. In 2000 we thinked SQL was boring, mostly because sql algebra could be a bit boring. Then we found this book written by one of the father of SQL. Years ago Google and then Facebook popped out with new incredible ideas, for improved and super fast scalability, which eventually turned to the “NoSQL” mantra.

    But NoSQL is a mature technology, or it is only a path traced by the Social company out of there? Let’s explore together…


    Read More
  • WISP Manifesto

    calendar Aug 14, 2011 · 2 min read
     en it  · cloud-computing ideas nosql
     ·
    Share on: twitter facebook linkedin copy

    We talked about ”Web applIcation Service Provider” (WISP) in the past days. So what are the specification for a Service Provder wanting to be a WISP?


    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
  • Avoid Kafka if unsure (think twice series)

    calendar Dec 2, 2019 · 2 min read
     en featured knowledgebase sql  · java nosql
     ·
    Share on: twitter facebook linkedin copy
    Avoid Kafka if unsure (think twice series)

    Some co-workers started using Apache Kafka con a bunch of our Customers.

    Apache Kafka is a community distributed event streaming platform capable of handling trillions of events a day. Initially conceived as a messaging queue, Kafka is based on an abstraction of a distributed commit log[*].
    To get this goal, Apache Kafka needs a complex servers setup, even more complex if you want the certification for the producing company (Confluent).  Now, if you are planning to use Kafka like a simple JavaMessaeSystem (JMS) implementation, think twice before going on this route.

    PostgreSQL 12 offers a fair (and open source) partition implementation, whereas if money are not a problem, Oracle 12c can happy scale on billions of record before running into troubles (and ExaData can scale even more).

    PostgreSQL and Oracle offer optimizations for partitioned data, called “Partition Pruning” in PostreSQL teminology:

    With partition pruning enabled, the planner will examine the definition of each partition and prove that the partition need not be scanned because it could not contain any rows meeting the query's WHERE clause. When the planner can prove this, it excludes (prunes) the partition from the query plan.
    This feature is quite brand new (popped in PostreSQL 11) but it is essential to a successful partition strategy. Before these feature, partitioning was a black magic art. Now it is simpler to manage.
    Read More
  • 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
  • PostgreSQL Queue in Java + Spring

    calendar Mar 29, 2025 · 4 min read
     en knowledgebase sql  · java nosql postgresql
     ·
    Share on: twitter facebook linkedin copy
    PostgreSQL Queue in Java + Spring

    We already discussed about Queue management solutions in the past, and I am always happy to write about it. Queue managers are not easy to implement, and there is a reson if IBM MQ Series is still a successful product. Some month ago, a big bank customer asked me to provide a small queue implementation to increase asynchronous internal processing of our payment solution.

    The project had very strong contraints: I could not use existing queue system because they were not yet available, and I need to be able to provide microservice parallelism in a cloud-environent.

    I have very little time to provide a solid solution, and re-inventing the wheel was not an option. Performance was important, but we plan to have a managable numbers of transactions per seconds, far behind modern cloud database capacity.

    Challenge accepted.


    Read More

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