[mythtv] State of play Re. DB support (MySQL versions, Postgresql etc.)
ijr at case.edu
Sun May 14 19:08:02 UTC 2006
On Sunday 14 May 2006 3:03 pm, Colin Guthrie wrote:
> Isaac Richards wrote:
> > It won't. If anything, we'll be moving to an embedded db w/ a custom
> > server on top of that.
> I've seen some comments about SQLite right enough... Not had the best of
> experiences with SQLite myself (speed wise), but then you don't
> specifcally say SQLite so I wont put words in your mouth!!
> Anyways, quick question, should I use ::lastInsertId() or code such that
> I can reselect out the id based on the value inserted?
Using the MSqlQuery::lastInsertId() is preferable.
> And do you see any use for the multi row insert wrapper class mentioned
> earlier in this thread? I can create it if you want, but wont bother if
> it's not gonna be of any use? I only mentioned it as I think I recall
> some people mentioning the database being hammered in earlier threads...
> Perhaps e.g. mythfilldatabase could use it? (I don't know that code so I
> am just guessing here).
Up to you. mysql-isms abound already, one more doesn't really hurt anything.
More information about the mythtv-dev