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 Misterio Esp8266 SQLite
Status
Links icon
GitHub LinkedIn
About
github linkedin rss
  • 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
  • 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
  • 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

  • Misterio Is Back
  • Netflix retro weird spirit
  • Yakuza Blues
  • FreeBSD on MacBook Mid 2009 with BroadCom WIFI

Latest comments

    Giovanni Giorgi

    Copyright 1999-  GIOVANNI GIORGI. All Rights Reserved

    to-top