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
  • 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
  • oracle mass table drop

    calendar Jul 3, 2007 路 1 min read
     blog-objectsrootcom en  路 build easy oracle postgresql script small sql table ui vi
     路
    Share on: twitter facebook linkedin copy
    oracle mass table drop

    Sometimes I need to build a small script to delete a huge set of tables of a schema.


    Read More
  • Postgres performance tuning

    calendar Apr 3, 2008 路 1 min read
     blog-objectsrootcom en knowledgebase software sql  路 database postgresql sql
     路
    Share on: twitter facebook linkedin copy
    Postgres performance tuning

    After a bit of work, I have managed to optimize the performance of my Postgresql Server.


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