D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] Sqlite front end

 

On 22/02/13 11:20, Neil Winchurst wrote:
On 22/02/13 11:03, tom wrote:
On 22/02/13 09:28, Gordon Henderson wrote:
On Fri, 22 Feb 2013, Neil Winchurst wrote:

Being in the area I called on Kevin Lucas yesterday. We got to
talking about databases and he suggested I try sqlite. I have
installed version 3 with no problem. Now I need a gui front end.
Kevin suggested using Libre Office for this purpose but I cannot yet
work out how to do that.

Can onyone on the list point me in the right direction please? I have
also downloaded sqlitestudio but that doesn't seem to start properly.
Any help gratefully accepted.

https://code.google.com/p/phpliteadmin/

it's in the same vein as phpMyAdmin, but for sqlite. You'll need a
local web server configured with php to use it though.

Gordon

Once you've got the odbc stuff configured for OOffice can you not use
Base as a front end gui?
Tom te tom te tom

As far as I know Base is a database in its own right, not a front end. It is, in my opinion, very over complicated. And, in my opinion anyway, it should have its own scripting language. It tries to use V Basic for the purpose, but this was never meant to be used for this purpose.

I was using Paradox for all this 20 years ago. Linux still has not caught up.

Neil

Just for my own amusement I went and created a blank file, used ODBCConf to create a system wide ODBC reference and then connected to that file using Base and created tables/forms etc. Its not brilliant but it works and if you build up a library of SQL commands for certain actions then useable.
Tom te tom te tom

--
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq