[Phpsqliteadmin-devel] edit row patch

[Steve D. <sd...@wo...>]

Hey guys,

I'm working on an edit row patch right now.  I've actually got it
working, and I'll submit it once you can delete a row, too.

The only bad side effect that I noticed is that SQLite doesn't allow the
LIMIT clause when using DELETE or UPDATE unlike MySQL.  Bummer.  So what
happens is when you update a row there's no way to tell it to limit it
to one instance.  The workaround I coded was to update the row where
the old values match.  That'll work, but it will also update/delete if
there's more than one row.  If you guys know a workaround to create a
safety net, that'd be cool.  Of course, it's a rare occurence it'd be
needed, but still.

The other thing is that in order to access SQLite through the web on
linux, the database AND it's directory need to be world writeable.  So
I created a new directory named db and dumped phpsla.sqilte in there.

What's the best way to submit patches anyway?

Steve