I'll throw my 2 cents in... A Node.js server, and use a web frontend, or electron/nwjs which are browsers that include node, and can be standalone apps.
On Tue, Nov 14, 2017 at 1:33 PM, Balaji Ramanathan < balaji.ramanat...@gmail.com> wrote: > Thank you everyone for your suggestions. > > Looked at Xojo. Not sure if the free version will stick around. And there > is no way to save and reuse reports from one session to another in the free > version. Creating and recreating the report every time is going to become > tedious very soon. > > Continuing to use Access as a front end and connecting to my db using odbc > is definitely an option. I wanted to move away fully from Access, so I am > going to keep that as a backup option. > > I am leaning towards tcl/tk given the endorsement from both Peter and DRH. > So, I downloaded tcl/tk version 8.6.7 from magicsplat ( > http://www.magicsplat.com/tcl-installer/index.html), and then ran > tclsh.exe. In the resulting command window, I typed "sqlite3 db1 <path to > my sqlite database" as instructed on this page on the sqlite website: > https://sqlite.org/tclsqlite.html . And all I got was "invalid command > name sqlite3". So, I am stuck. What did I do wrong? > > BTW, the www.tcl-lang.org website has been down for at least the past 3 > days it looks like. Not sure how to interpret the reliability of a > technology whose home website is down for days at a time. > > Balaji Ramanathan > > On Tue, Nov 14, 2017 at 6:00 AM, < > sqlite-users-requ...@mailinglists.sqlite.org> wrote: > > > > > ---------- Forwarded message ---------- > > From: Peter Da Silva <peter.dasi...@flightaware.com> > > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > > Cc: > > Bcc: > > Date: Mon, 13 Nov 2017 22:03:34 +0000 > > Subject: Re: [sqlite] Best way to develop a GUI front-end > > Since sqlite originated as a Tcl extension it’s got excellent Tcl > > bindings, and Tcl has an excellent platform-independent GUI in Tk, so it > > seems to me that would be the best and simplest way to create a GUI front > > end for sqlite. > > > > > > > > ---------- Forwarded message ---------- > > From: Richard Hipp <d...@sqlite.org> > > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > > Cc: > > Bcc: > > Date: Mon, 13 Nov 2017 17:06:20 -0500 > > Subject: Re: [sqlite] Best way to develop a GUI front-end > > On 11/13/17, Peter Da Silva <peter.dasi...@flightaware.com> wrote: > > > Since sqlite originated as a Tcl extension it’s got excellent Tcl > > bindings, > > > and Tcl has an excellent platform-independent GUI in Tk, so it seems to > > me > > > that would be the best and simplest way to create a GUI front end for > > > sqlite. > > > > +1 > > > > -- > > D. Richard Hipp > > d...@sqlite.org > > > > > > > > ---------- Forwarded message ---------- > > From: Tim Streater <t...@clothears.org.uk> > > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > > Cc: > > Bcc: > > Date: Mon, 13 Nov 2017 22:22:29 +0000 > > Subject: Re: [sqlite] Best way to develop a GUI front-end > > On 13 Nov 2017, at 21:54, Balaji Ramanathan <balaji.ramanat...@gmail.com > > > > wrote: > > > > > Is there a third party free tool like MS Access that would allow me > > to > > > connect to a SQLite db in the back-end and enable me to create a custom > > > front-end to it with forms and reports? All my searches for this kind > of > > > tool only lead me to tools like SqliteStudio, which is a GUI front end > > for > > > SQLite, but not a programmable one like I want. If anyone can point me > > > towards a programmable GUI front-end development tool (preferrably > > > open-source, but just free and well-maintained is sufficient), I would > > > appreciate it greatly. > > > > There is Xojo (www.xojo.com) which has SQLite built in and has reports > > (which I have never used). It's cross-platform and you create your own > GUI > > front end with windows, buttons etc. It's free to use for development, > but > > if you want to compile and build a stand-alone application (.exe or .app) > > then you buy a licence. There is a Lite licence to build for one platform > > which is not a high cost. > > > > > > > > -- > > Cheers -- Tim > > > > > > ---------- Forwarded message ---------- > > From: Bart Smissaert <bart.smissa...@gmail.com> > > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > > Cc: > > Bcc: > > Date: Mon, 13 Nov 2017 23:52:18 +0000 > > Subject: Re: [sqlite] Best way to develop a GUI front-end > > As you are familiar with VBA I can see two other options: > > > > 1. Use Christian Werner's ODBC driver from Access (or Excel): > > http://www.ch-werner.de/sqliteodbc/ > > > > 2. Use Olaf Schmidt's COM dll with Access (or Excel): > > http://www.vbrichclient.com/#/en/About/ > > > > RBS > > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
