[Lazarus] Cross Platform SQL Client/Editor

[Mark Morgan Lloyd]

Marcos Douglas wrote:
> On Fri, Jan 1, 2016 at 8:39 PM, Anthony Walter <sysrpl at gmail.com> wrote:
>> If the pickings are slim in answer to Question 1, are they many people here
>> who want a simple cross platform SQL client/editor, possibly with both MySQL
>> and MSSQL support?
> 
> I don't use Linux for development (yet) but I work with MSSQL every day.
> Would be great if we had such tool. Thanks.

Things like this usually stall when the app for some reason needs to 
either inject backend-specific SQL, or (thinks it) needs to validate an 
SQL query or command before it can submit it. Without wanting to sound 
negative, I've yet to see a GUI frontend which is remotely usable when 
attached to a table with a few billion rows.

Having said that and stepping back a little from the problem, it appears 
that PostgreSQL uses YACC-style tools (i.e. Bison etc.) to parse SQL 
syntax before executing it. A good starting point might be to make sure 
that pyacc has the cojones to parse SQL, and then before attempting to 
support any particular backend writing a fairly complete set of parsing 
rules.

-- 
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]