Re: Finding and Reminding, tech issues, 3.0 and beyond

On 19/04/10 10:53, Steve Frécinaux wrote:
On 04/15/2010 02:05 PM, Martyn Russell wrote:
If you had a real database,

Are you suggesting SQLite is not a real database or that an application
"would use" a real database to continue your point?

I think what Bastien meant is "if tracker exposed itself as a real
database", i.e. exposing a SQL API. Using sqlite, bdb or plain text for
storage is an implementation detail.

We did consider this already.

The point is that database theories and concepts are teached to pretty
much everyone doing CS at school, which is a good thing in an ocean of
worse, I agree.

Sure, I came from knowing database theories and SQL before I knew SPARQL too, but as Owen already said, it really isn't that difficult if you knew that before. We still use things like SELECT, WHERE, COUNT, AS, DISTINCT, INSERT, etc.

In the end, it is much of a muchness. SQL is far from trivial to learn
and each database optimises for different things. Not to mention the
different versions and extensions of SQL depending on the database you
use. Why would a user really care about any of that unless they were
going to share their data in the first place?

At least, there exist specific tools for manipulating SQL data. For
exemple there are a load of ORM libraries for pretty much any language
out there that doesn't force one to build queries in plain text (which
is tedious, and error-prone (accidental SPARQL injection, someone?)

Which tools are you referring to here?
How are they built then?
Are said tools extensible to any schema changes?

Did you write an ORM engine for SPARQL queries for tracker?

Yes we did.


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]