Re: [sqlite] Best way to develop a GUI front-end

2017-11-16 Thread R Smith
On 2017/11/15 11:56 PM, Simon Slavin wrote: You are locking yourself into the Windows system. By all means use this solution as a prototype but if you ever find yourself saying "I’m now doing serious programming." do what you can to escape Windows, Office, and Visual-*. Otherwise you will

Re: [sqlite] Best way to develop a GUI front-end

2017-11-16 Thread Balaji Ramanathan
ite-users@mailinglists.sqlite.org> Cc: Bcc: Date: Wed, 15 Nov 2017 13:11:56 + Subject: Re: [sqlite] Best way to develop a GUI front-end I contacted the Tcl core team and this is the response from Steve Landers: > tcl-lang.org was a temporary measure a few years ago when the .tk DNS went missing. It wa

Re: [sqlite] Best way to develop a GUI front-end

2017-11-16 Thread Chris Locke
> For now, I am going to start > with a windows forms application in vb.net or forms in OpenOffice. I'd install SharpDevelop ( http://www.icsharpcode.net/opensource/sd/Default.aspx). Download v4.4 if you plan on using VB.Net, as the newer v5 doesn't support VB - only C#. SharpDevelop is a 15 MB

Re: [sqlite] Best way to develop a GUI front-end

2017-11-15 Thread Simon Slavin
On 15 Nov 2017, at 8:16pm, Balaji Ramanathan wrote: > Thank you very much for all your suggestions. For now, I am going to start > with a windows forms application in vb.net or forms in OpenOffice. You are locking yourself into the Windows system. By all means

Re: [sqlite] Best way to develop a GUI front-end

2017-11-15 Thread Richard Hipp
On 11/15/17, Peter Da Silva wrote: > Tk is platform independent, so long as you don’t do UNIX-specific stuff (eg, > assume UNIX file paths and stuff) any Tk app should work just fine on > Windows. A majority of the SQLite source code and also the Fossil SCM source

Re: [sqlite] Best way to develop a GUI front-end

2017-11-15 Thread Igor Korot
Take a look at wx{Phoenix, Python}. It is much simpler, written in python, supports all its versions, and there demos and samples on its website - www.wxpython.org Thank you. On Wed, Nov 15, 2017 at 2:32 PM, Peter Da Silva wrote: > Tk is platform independent, so

Re: [sqlite] Best way to develop a GUI front-end

2017-11-15 Thread Peter Da Silva
Tk is platform independent, so long as you don’t do UNIX-specific stuff (eg, assume UNIX file paths and stuff) any Tk app should work just fine on Windows. You may need to tweak the fonts, eg: if { $tcl_platform(platform) eq "windows" } { set font {Arial} } else { set font {Helvetica} }

Re: [sqlite] Best way to develop a GUI front-end

2017-11-15 Thread Balaji Ramanathan
Thank you very much for all your suggestions. For now, I am going to start with a windows forms application in vb.net or forms in OpenOffice. Tcl/Tk is a steeper learning curve, and if someone can point me to some good resources that will walk a beginner through the development of a windows GUI

Re: [sqlite] Best way to develop a GUI front-end

2017-11-15 Thread Peter Da Silva
On 11/14/17, 10:32 PM, "sqlite-users on behalf of J Decker" wrote: > Initially I was interested in tcl/tk, and still am, but I'm not sure about > the tcl/tk packaging that would be necessary to make use on multiple >

Re: [sqlite] Best way to develop a GUI front-end

2017-11-15 Thread Peter Da Silva
I contacted the Tcl core team and this is the response from Steve Landers: > tcl-lang.org was a temporary measure a few years ago when the .tk DNS went > missing. It wasn’t advertised but I guess it is now. > I’ve fixed it The official site is still at tcl.tk.

Re: [sqlite] Best way to develop a GUI front-end

2017-11-14 Thread J Decker
On Tue, Nov 14, 2017 at 8:14 PM, jungle boogie wrote: > Thus said J Decker on Tue, 14 Nov 2017 13:35:55 -0800 > >> 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

Re: [sqlite] Best way to develop a GUI front-end

2017-11-14 Thread Simon Slavin
On 15 Nov 2017, at 4:14am, jungle boogie wrote: > Funny you should mention that. I've been looking at node.js and curious how > sqlite would be implemented. Can you recommend a npm package for it? SQLite is implemented as promises, allowing it to be programmed as if

Re: [sqlite] Best way to develop a GUI front-end

2017-11-14 Thread jungle boogie
Thus said J Decker on Tue, 14 Nov 2017 13:35:55 -0800 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. Funny you should mention that. I've been looking at node.js and curious how sqlite

Re: [sqlite] Best way to develop a GUI front-end

2017-11-14 Thread Igor Korot
Hi, Did you look at wxPython (or wxPhoenix)? It was recenty saw a new release.. Thank you. On Tue, Nov 14, 2017 at 3:39 PM, Peter Da Silva wrote: > On 11/14/17, 3:33 PM, "sqlite-users on behalf of Balaji Ramanathan" >

Re: [sqlite] Best way to develop a GUI front-end

2017-11-14 Thread Peter Da Silva
On 11/14/17, 3:33 PM, "sqlite-users on behalf of Balaji Ramanathan" wrote: > 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

Re: [sqlite] Best way to develop a GUI front-end

2017-11-14 Thread J Decker
t 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...@s

Re: [sqlite] Best way to develop a GUI front-end

2017-11-14 Thread Balaji Ramanathan
.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 G

Re: [sqlite] Best way to develop a GUI front-end

2017-11-14 Thread dmp
> Date: Mon, 13 Nov 2017 15:54:42 -0600 > From: Balaji Ramanathan <balaji.ramanat...@gmail.com> > To: sqlite-users@mailinglists.sqlite.org > Subject: [sqlite] Best way to develop a GUI front-end > > Hi, > > I have been using SQLite without any programming language

Re: [sqlite] Best way to develop a GUI front-end

2017-11-14 Thread Warren Young
On Nov 13, 2017, at 2:54 PM, Balaji Ramanathan wrote: > > In the past, I have maintained my data in an Access database That’s the sort of application that the open source world just is not very good at recreating. F/OSS people hear “database” and think SQLite or

Re: [sqlite] Best way to develop a GUI front-end

2017-11-14 Thread Drago, William @ CSG - NARDA-MITEQ
> > This will work with any .NET/Visual Studio language (C#/F#/VB): > > Not sure this will work with VBA though. > VB .NET is very different from VBA (or VB6), so that won't be that easy, > unless I am missing something. > > RBS It's not that hard to go from VBA to VB .NET. The part I failed to

Re: [sqlite] Best way to develop a GUI front-end

2017-11-14 Thread Donald Griggs
Regarding: *1. Use Christian Werner's ODBC driver from Access (or Excel):* *http://www.ch-werner.de/sqliteodbc/* If you prefer an open solution to Excel or Access, you may want to pair Werner's ODBC driver with LibreOffice Base or Calc.

Re: [sqlite] Best way to develop a GUI front-end

2017-11-14 Thread Bart Smissaert
inglists.sqlite.org> > > 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.d

Re: [sqlite] Best way to develop a GUI front-end

2017-11-14 Thread Don V Nielsen
Sent: Monday, November 13, 2017 6:52 PM > > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > > 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 Christi

Re: [sqlite] Best way to develop a GUI front-end

2017-11-14 Thread Drago, William @ CSG - NARDA-MITEQ
> -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Bart Smissaert > Sent: Monday, November 13, 2017 6:52 PM > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Subject: Re: [sqlite] Best wa

Re: [sqlite] Best way to develop a GUI front-end

2017-11-13 Thread Bart Smissaert
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 On Mon, Nov 13, 2017 at 9:54 PM, Balaji

Re: [sqlite] Best way to develop a GUI front-end

2017-11-13 Thread Tim Streater
On 13 Nov 2017, at 21:54, Balaji Ramanathan 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

Re: [sqlite] Best way to develop a GUI front-end

2017-11-13 Thread Richard Hipp
On 11/13/17, Peter Da Silva 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 >

Re: [sqlite] Best way to develop a GUI front-end

2017-11-13 Thread Peter Da Silva
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. ___ sqlite-users

[sqlite] Best way to develop a GUI front-end

2017-11-13 Thread Balaji Ramanathan
Hi, I have been using SQLite without any programming language so far. I maintain the data in SQLite and use SqliteStudio (www.sqlitestudio.pl) for inputting data into it and running queries to look at outputs. However SqliteStudio does not have a programmable back-end that allows me to take