Alternative to SQL

2009-05-04 15:55:57 +0200

Database alternative, for people just browsing and scanning, I'll write in staccato.

  • Relational model pretty good, but we need a better implementation of the relational model, SQL, at least the way it's used now, is just to primitive and cumbersome.
  • Lot's of new languages for the JVM, but we're still using SQL to retrieve data from databases. Many programmers may even think that is the only way to retrieve data!
  • ORM is worst of both world
    • Reinventing the wheel, caching, optimal data retrieval, query optimization
    • Relational model is more natural to retrieve data then object oriented model
    • Inheritence is not possible the way it's possible in OO, but same functionality is still possible.
  • Java Programmers are spending a LOT of time creating queries, doing optimization, thinking how to retrieve data. Java is improving, but SQL is just largely the same as it was 10 ago.
  • SQL / Database integration in Java is still poor. ORM frameworks just hide away the database - usually resulting in a lot of work for database administrators and programmer's just to tweak ill formed sql.

In short, where's a new language for the relation model and why isn't that language or technology emerging? What would be nice is:

  1. A better language to access a relation database, that doesn't involve lots of subqueries and joins to retrieve data.
  2. A database query langauge that is truly embedded in the programming language I daily work with (Java), and not hidden behind persistence managers, xml files,  application servers.  Or just as worse, SQL hidden in quoted string or text files.
  • For 1. After some searching, I found an alternative to SQL, Tutorial D.  The language isn't main stream, but is interesting to read about. Especially if you think SQL and (relational) databases are the same.
  • Also I heard a while ago about .QL on the 25 year anniversary of my university, but that's far from mainstream either.
  • For .Net there's LinQ, but that's little use for me as Java software developer.  At least Microsoft has a solution for 2.

Read more

Diagram software

2009-05-01 12:55:20 +0200

Sometimes a diagram says more then a thousands words. That being said, what is good software to draw diagrams? I could quickly draw a diagram on my paper notepad, but known I wanted to visualize my diagram. I tried Dia. Advantage of that software is that is very basic, so you don't have to waste time on any nifty features more expensive diagram software may have. Disadvantage is the amazingly user unfriendly interface.
Well, I don't know Diagram Drawing program is the best one, but I did find a nice review of several free versions: Free Diagram Software. There are already several on line versions, which is quite cool.

Read more

Archive

subscribe via RSS