In questo articolo del 2012, si legge che Reddit avrebbe un database da due tabelle.

Le due tabelle si chiamano “Cose” e “Dati” (i.e. attributi delle cose).

“Cose” contiene una riga per ogni oggetto del sistema (utenti, forum, ecc) e attributi base come il tipo e la data di creazione.

Read More

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

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. Launching %WINDIR%\\System32\\odbcad32.exe

(the 32bit guy of the odbc drivers side) I was able to get the same error… and this was helpful:

Read More

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

Read More

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 in milliseconds or in seconds: no word about it!
• Returned value are often inconsistent, so we cannot use it very well.

Anyway, for a "quality oriented" sampling of data, for finding out most used calls and so on, Elvyx can help a bit.

From the website:

Read More

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 on two different and big projects, with a “zero time” to teach them hibernate. So I decided to put here my advices, hints, tips and tricks, for the rest of the guys around the World.

Read More

 

Per un importante cliente di ValueTeam, ho sviluppato per un'applicazione chiamata PDFGenerator, che è stata pacchettizzata come un vero e proprio prodotto.
PDFGenerator nasce in una situazione caratterizzata da un alta variabilità dei requisiti utente.

Le specifiche del progetto hanno subito variazioni significative nell'arco di quattro anni, ed alla fine i requisiti utente erano parecchio mutati.  L'applicazione, già fatturata, non era ancora stata validata dal Cliente finale, ed era passata di mano moltissime volte.
Da un lato c'era la necessità di fornire uno strumento semplice da utilizzare, dall'altro la possibilità di espanderlo nel momento in cui le esigenze di Business del Cliente fossero cambiate, contenendo i costi di sviluppo.
Questi due aspetti erano acuiti in questo contesto, poiché i dati potevano provenire da fonti assai eterogenee per tipologia (database o personale del marketing) e l'utente finale doveva elaborarle in modo uniforme e rapido.
Per queste ragioni la specifica era cambiata spesso nel tempo, e la sfida era notevole.
PDFGenerator è semplice dal punto di vista software, e la sua forza sta nell'idea, e nella capacità di capire l'utente finale.

Read More

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 needs, tuning postgres is easy as working with MySql. And with postgres you get for free Transaction and PL/SQL without the need to do extra configuration or tuning or your database.

Read More

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.

Read More

Oracle buys BEA and Sun buys MySql.

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

<joking> 

Any bets on the next money-based-news?

I'm going for

• Oracle buys Sun: "We need more hardware to run Oracle and WebLogic together! "
  
• Google buys Oracle: "We have *even* more hardware...come on!"
  
• Apple buys Google: "So nice LOGO", retrodating a bunch of stock options, I suppose.
  
• Microsoft buys Apple ("So annoied their are more cool then us!") and shut down all them all so you will end up using their search engine, I hope.

</joking> 

Read More

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, because it is so easy to isolate spam from true comments.
I will not keep a record of this spam, sorry

Read More

Biblio Wolf (Bwolf for firends) is a webapp app for managing a book collection. BWolf is written in python using the Django web framework, and it is born from a Customer request. BWolf is open source, and you can get a full description here including links to downloads. I will mantain a blog of all the work I will do. In the last two months I set up a Subversion Repository and played a little with Django.

 

Read More