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

[Martyn Russell <martyn lanedo com>]

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.

--
Regards,
Martyn