Marcos Douglas wrote:
On Fri, Jan 1, 2016 at 8:39 PM, Anthony Walter <sys...@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]
--
_______________________________________________
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus