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
  • 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
  • Storia dei database

    calendar Dec 17, 2008 路 3 min read
     it software sql  路 formazione
     路
    Share on: twitter facebook linkedin copy
    Storia dei database

    NB: Questo 猫 la storia super rapida dei database relazionali, e non 猫 ancora completata. L’idea 猫 di confrontare la storia del modello E-R con quello dello sviluppo OOP, evidenziando simmetrie e differenze


    Read More
  • H2 Database Engine

    calendar Apr 9, 2009 路 2 min read
     en knowledgebase sql  路 database java jug
     路
    Share on: twitter facebook linkedin copy
    H2 Database Engine

    The creator of HSQL has created a new Java database called H2. We have tried it!


    Read More
  • The destiny of MySQL?

    calendar Apr 21, 2009 路 1 min read
     en software sql  路 mysql news opensource
     路
    Share on: twitter facebook linkedin copy
    The destiny of MySQL?

    Slashdot underlines there are too much forks of MySQL on the way.


    Read More
  • MySQL Installing MySQL on Mac OS X

    calendar Oct 26, 2009 路 1 min read
     knowledgebase sql  路 mysql
     路
    Share on: twitter facebook linkedin copy
    MySQL  Installing MySQL on Mac OS X
    If you're trying to use MySQL with phpMyAdmin, you've set up the phpMyAdmin's config.inc.php, and you're getting an error saying "Client does not support authentication protocol requested by server; consider upgrading MySQL client", you need to set the password on the mysql command line using the OLD_PASSWORD('password') routine.

    For example:


    Read More
  • SQLite alter table

    calendar Jul 25, 2010 路 1 min read
     it sql  路 cute embedded programming small smart sql sqlite
     路
    Share on: twitter facebook linkedin copy

    SQLite is a small, powerful embedded database. A friend of mine started using it about聽six years ago. Some years ago it comes also聽on top of 聽Python 2.5. It is used inside

    • FileMaker Bento: its ultra customized model is based on a big sqllite db
    • DropBox聽client, to store its internal state
    • iPhone: stores your SMS and also other stuff. It is widely used by apps.
    • Apple Safari uses it for HTML5 storage support
    • Google Gears uses it
    • ...and in a lot of embedded product.

    I was annoyed because until version 3.1.3 SQLite聽did not provide an alter table syntax聽but…聽it is quite easy to emulate it with something like this, even if it required a bit of work:


    Read More
  • Introduzione a SQL Server 2008 Express

    calendar Jan 30, 2011 路 4 min read
     featured it sql  路 c database sqlserver
     路
    Share on: twitter facebook linkedin copy

    In questo articolo parleremo di Microsoft SQL Server.

    SQL Server nasce inizialmente da uno sforzo congiunto di聽Microsoft, Sybase and聽Ashton-Tate che nel 1989 creano tale prodotto avente come target OS/2.

    Dopo alcune vicessitudini Microsoft si smarca da Sybase e SQL Server versione 6.0 猫 la prima versione per Windows NT che non ha pi霉 dipendenze di copyright da Sybase.


    Read More
  • SQL Server: meta programmazione e meta descrittori

    calendar Feb 6, 2011 路 2 min read
     it sql  路 c sql sqlserver
     路
    Share on: twitter facebook linkedin copy

    In questo articolo della serie SQL Server, vedremo come creare 聽in modo dinamico delle istruzione per impostare delle policy di sicurezza. Creeremo da zero una stored procedure chiamata sp_FixOverallGrant che in modo dinamico imposter脿 i profili di sicurezza per due utenze, una in lettura e scrittura (EBRB0_APP) ed una in sola lettura (EBRB0_USR).


    Read More
  • SQL Server e Python

    calendar Feb 17, 2011 路 1 min read
     it python sql  路 python sql sqlserver
     路
    Share on: twitter facebook linkedin copy

    L’integrazione tra .NET e SQL Server 猫 data per scontata: in questo articolo esploreremo invece 聽come accedere a SQL Server da Python. Uno dei vantaggi di python 猫 che 猫 un linguaggio molto facile da imparare, con un notevole numero di librerie e un’ottima integrazione multi piattaforma. Oltre a ci貌 python offre un sistema di installazione rapido delle librerie (come 聽Ruby e Perl).


    Read More
  • 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
    • ««
    • «
    • 1
    • 2
    • 3
    • »
    • »»

Recent Posts

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

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-06-14 16:44
    Giovanni Giorgi

    Copyright 1999-  GIOVANNI GIORGI. All Rights Reserved

    to-top