database – Gioorgi

Simple method to add historic feature to SQLite

April 9, 2021 April 6, 2021 / English Content, IT Featured, Knowledgebase, Structured Query Language (SQL) / database, sqlite / Leave a Comment

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 …

Simple method to add historic feature to SQLite Read More »

Smart Sync

March 22, 2021 March 15, 2021 / English Content, Gio's Software Projects / database, mssqlserver, oracle, sqlite / Leave a Comment

On 2002, I was forced to build a small java class to “sync” two databases (sorry for Italian): SmartSync used the Metadata offered by JDBC API to be able to copy data between two tables. In the last years I evolved it to be able to support a special use case called “dump to SQLite”. …

Smart Sync Read More »

Semplice metodo per storicizzare i dati su database

March 17, 2021 April 7, 2021 / Italian Content, Structured Query Language (SQL) / database, oracle / Leave a Comment

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. Autori: Ernesto Ghetti (idea), Giovanni Giorgi …

Semplice metodo per storicizzare i dati su database Read More »

Windows x64: 32bit Odbc vs 64bit Odbc

November 10, 2011 November 10, 2011 / English Content, Knowledgebase / database, I-hate-64-bit, oracle, visio

I run into a very big trouble on these days. My big company delivered to me a Windows7 64bit system (first error) I asked for Office 64 bit and Visio2007 32 bit I tried to connect to Oracle (second error) to reverse engenieer a DB with Visio2007 I got a “driver architecture” error under Visio2007. …

Windows x64: 32bit Odbc vs 64bit Odbc Read More »

Introduzione a SQL Server 2008 Express

January 31, 2011 February 21, 2019 / IT Featured, Italian Content, Structured Query Language (SQL) / c#, database, history, sqlserver

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 …

Introduzione a SQL Server 2008 Express Read More »

H2 Database Engine

April 9, 2009 February 21, 2019 / English Content, Knowledgebase, Structured Query Language (SQL) / database, java, jug

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

Java JDBC Probe

April 4, 2009 May 27, 2009 / English Content, Knowledgebase, Software / database, db, debugging, java, jdbc, News, tip, vote5

Tired of prepared statement written down on the code? Tired of Hibernate, and willing to come back to crude SQL debugging? No problem, dudes! We tried Elvyx, a JDBC probe, without a full success. Our quality vote is 5, because of the following bad aspects: Very poor documentation. It is unclear if timings are returned …

Java JDBC Probe Read More »

Hibernate Speedest introduction

September 22, 2008 April 21, 2009 / English Content, Knowledgebase, Software / database, hibernate, java, Programming Languages, tutorial

In this article I will introduce you to Hibernate 3 persistence framework. This article is worth to read, because give you a very fast track to Hibernate; I have used this tool for the past six years, when only the good 2.x series was out of there. Then I have the lucky of training two teams …

Hibernate Speedest introduction Read More »

The Valueteam PDFGenerator

April 16, 2008 January 18, 2009 / English Content, Legacy ObjectsRoot.com / .NET, ant, api, ARC, asp, business, car, commercial, cute, database, design, email, excel, file, font, import, interface, j2ee, java, macro, microsoft, pd, pdf, prove, rapido, Software, test, tip, ui, valueteam, vi, war, web

Per un importante cliente, abbiamo sviluppato una applicazione chiamata PDFGenerator, che è stata pacchettizzata come un vero e proprio prodotto.
Vediamo come è stato possibile...

Postgres performance tuning

April 4, 2008 February 21, 2019 / English Content, Knowledgebase, Legacy ObjectsRoot.com, Software, Structured Query Language (SQL) / database, postgresql, sql

After a bit of work, I have managed to optimize the performance of my Postgresql Server. I have spent a saturday morning digging around postgresql, using the fantastic komodo editor, and I am happy with the final solution. I followed some suggestion on power PostgreSQL site, and now my postgres is blazing fast. For small …

Postgres performance tuning Read More »

Dynamic languages troubles

January 31, 2008 January 18, 2009 / English Content, Legacy ObjectsRoot.com / again, ant, api, ARC, build, business, C Language, car, code, complex, database, design, drupal, easy, eclipse, example, fix, hard, hosting, http, ibm, import, java, lion, microsoft, perl, php, plugin, plugins, project, projects, python, ruby, San Francisco, simple, small, smalltalk, Software, sql, stop, system, tools, trouble, ui, unix, vm, war, web, world

I have read http://www.manageability.org/blog/stuff/chandler-failure and I think it is very danger way of exposing concepts.

In the article pointed out, the quite dead Chandler project is compared to the multi-billion Eclipse project. And then a too easy analysis is done against dynamic languages, where Java is the absolute winner.

I will try to fix some of the things said there, and to add also my two cents here :)

Shopping in the IT

January 22, 2008 January 18, 2009 / English Content, Legacy ObjectsRoot.com / ant, apple, ARC, database, db, engine, file, good, google, hard, make, microsoft, mysql, News, opinion, oracle, ping, search, search engine, Software, sql, ui, war, web, yahoo

Oracle buys BEA and Sun buys MySql.

In reply,Migrosoft is hungry and is watching Yahoo :-)

Let's play a bit with these ideas :)

Blue Dragon Revision 2

May 16, 2007 January 18, 2009 / English Content, Legacy ObjectsRoot.com / ant, database, easy, Site, spam, vi, visio

Hi dear spammers, I am an announce. I love you so much I have decided to auto delete spam comments not already published. As you know, dear spammers, the anti spam on this site (called Blue Dragon) is able to shutup your nasty posts. Now blue dragon can also delete them from our big database, …

Blue Dragon Revision 2 Read More »

BWolf first installation

July 5, 2006 January 18, 2009 / English Content, Legacy ObjectsRoot.com / ant, book, database, db, developement, django, embedded, file, framework, future, link, links, python, script, sql, sqlite, subversion, table, test, testing, turing, ui, vi, web

Introducing first steps in Biblio Wolf

Database in depth

September 15, 2005 January 18, 2009 / English Content, Legacy ObjectsRoot.com / book, database, italia, Site, vi, web

I was happy to review a very nice book called "Database in Depth". Database in Depth Relational Theory for Practitioners By C.J. Date First Edition May 2005 Pages: 230 Series: Theory In Practice ISBN 10: 0-596-10012-4 | ISBN 13: 9780596100124 I reviewed it in English and Italian for my SIForge.org web site.Give it a try! …

Database in depth Read More »