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
  • 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
  • SQLite Tool-set

    calendar Jun 20, 2022 · 2 min read
     featured knowledgebase sql
     ·
    Share on: twitter facebook linkedin copy
    SQLite Tool-set

    Random list of very interesting projects (will be updated, guys).


    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
  • Semplice metodo per storicizzare i dati su database

    calendar Mar 16, 2021 · 6 min read
     it sql  · database oracle
     ·
    Share on: twitter facebook linkedin copy

    Abstract: Storicizzare i dati spesso è un attività considerata “secondaria”, ma un cattivo design porta a base dati difficili da ottimizzare e spesso poco comprensibili. In questo articolo illustriamo un semplice metodo che rispetta i dettami della teoria relazionale, è facile da capire ed è attivamente usato in produzione.


    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
  • 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
  • Outer full and inner SQL joins: you are wellcome

    calendar Aug 27, 2018 · 1 min read
     en sql  · sql
     ·
    Share on: twitter facebook linkedin copy

    For a complete description see https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

    All the Join you want
  • 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
  • Removing duplicate rows in PostgreSQL, Oracle and SQLite

    calendar Jun 15, 2017 · 1 min read
     en knowledgebase sql  · evil oracle postgresql sql
     ·
    Share on: twitter facebook linkedin copy
    Removing duplicate rows in PostgreSQL, Oracle and SQLite

    Sometimes you need to remove nasty duplicate on a table, based on a subset of the column. On every big database there is something called “rowid” which can be used to indentify a column in a unique way. On PostgreSQL is called ctid, as we shall see:


    Read More
  • Italian Accent Oracle fix

    calendar Feb 10, 2017 · 1 min read
     en sql  · oracle relax
     ·
    Share on: twitter facebook linkedin copy

    In Italian language we have accent words like àèéìòù


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

Recent Posts

  • Breve guida agli ETF
  • Salvadanaio remunerato di Satispay Conviene?
  • Interludio sul value investing
  • Anubis: DDos Protection

Latest comments

  • An update: The FAIR Package Manager: Decentralized WordPress infrastructure https://www.linuxfoundation.org/press/linux-foundation-announces-the-fair-package-manager-project-for-open-source-content-management-system-stability

    See https://news.ycombinator.com/item?id=44207503

    ...by daitangio
  • BuonGioorgi. Vero che HP Prime costi meno di DM42, ma l'RPN su Prime non è un gran che. Inoltre, la compatibilità con HP42s ed HP41c dove la mettiamo ? Su DM42(N) gira praticamente tutto. E per ultimo: devo spendere più di 200€ sulla baia per un HPxxx vecchio di anni, e che nessuno eventualmente riparerà, in caso si rompesse ? Meglio mettersi una mano sul cuore ed una sul portafogli... Disclaimer: non prendo soldi da SwissMicros :-)

    ...
    by Claudio
  • Buongiorno Giorgi. Post chiarissimo e ben scritto. Unica inesattezza: il TCNTn indica il valore attuale del conteggio, che di default parte da 0 ma che tu, nell'esempio modifichi per avere il delay di 1 secondo. Da come hai scritto tu ("Questo registro indica il valore al quale far scattare il timer. Il timer contera' a partire da zero fino....") in questo registro scriverei 15625 per farlo scattare ogni secondo.

    ...
    by Gianmarco
  • For timezone managmenet please refer to https://medium.com/devopsturkiye/how-to-set-timezone-for-kubernetes-cronjobs-691d3aaa34ef

    ...by daitangio

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-06-17 02:00
Giovanni Giorgi

Copyright 1999- 2025 GIOVANNI GIORGI. All Rights Reserved

to-top