@fizze wrote:
Ok, I’ll give it a shot once Im home.
In fact this looks nice, as it can strip/convert case of tags as well.Wouldnt it be kinda cool to have the mt-daapd DB be case insensitive ?
wouldnt be to hard to add a few UPPER() or LOWER()’s in the queries, would it ?
I could go either way on that. Like queries on mysql are already insensitive, so if everything was, I wouldn’t argue with that.
I just took a peek at db-sql.c, its where the browse magic happens, right ?
Being an Oracle guy I donno much about the features sqlite3, or the other backends, but I think those queries could be sped up.
Things like the double selects to get the count can be acheived by %%rowcount or cols, given sqlite3 supports that.
Yeah, but in the case of an indexed search I need not the rows returned, but the total rows without the offset/limit.
Also, it has to work with sqlite, mysql, and postgres at a minimum, which means sql-92 only.
If you can come up with performance enhancements that meet that criteria, I would certainly welcome them. I’m not much of a sql guy. Enough to hack about a bit, but by no means a dba.
As far as the slug goes, I want to add back the gdbm backend before a 1.0 release — it’s far snappier than sqlite on the slug.
— Ron