Re: [sqlite] Windows user app to display input form + reporting?
On Wed, 12 Mar 2014 19:05:01 +0100, big stone wrote: >What don't you like in base solution that made you ask for other ideas ? I just like SQLite's simplicity and speed, so wanted to make sure there weren't alternatives. Besides, it seemed a bit overkill to have her install and learn Base while she'll keep Word/Excel for the rest of her work. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Windows user app to display input form + reporting?
Hi Gilles, Only Base and Access seem to fit your broad requirements. With SQliteStudio.pl you can feed a sqlite database, but won't have form and reports. What don't you like in base solution that made you ask for other ideas ? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Windows user app to display input form + reporting?
On 03/12/2014 08:05 AM, Gilles Ganault wrote: On Wed, 12 Mar 2014 07:59:39 -0400, David Bicking wrote: Not exactly "lite" in size, but kexi does have most of the features of Access and uses sqlite to store its data: http://kexi-project.org/ Thanks for the link. It's currently not available for Windows, but I'll keep an eye on it. Sorry, I have used it under windows. Didn't know that the windows port was no longer available. David ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Windows user app to display input form + reporting?
On Wed, 12 Mar 2014 11:46:53 +, Simon Slavin wrote: >Any GUI you see is provided by a third party. There's no point in trying to >keep track of more than a hundred database management GUIs, many of which are >buggy, many of which interface with other database systems as well as SQLite. >The only result that would have is that if there is a bug in one of those >apps, someone would think the SQLite team is responsible, and word would get >passed around that SQLite is buggy. Got it. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Windows user app to display input form + reporting?
On Wed, 12 Mar 2014 07:59:39 -0400, David Bicking wrote: >Not exactly "lite" in size, but kexi does have most of the features of >Access and uses sqlite to store its data: > >http://kexi-project.org/ Thanks for the link. It's currently not available for Windows, but I'll keep an eye on it. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Windows user app to display input form + reporting?
On 03/11/2014 07:31 PM, Gilles Ganault wrote: Hello A friend needs to move from Excel to a database. The school won't pay for the full version of MS Office that includes Access, so recommended that she use LibreOffice Base instead. I just checked it out, and it seems to only be a front-end to the HSQLDB database which is written in Java. Before I check it out, I'd like to make sure there's no SQLite-based lighter solution where... 1. I'll run the commands originally to build the DB + tables 2. The Windows application will either display forms for her to enter data, or provide an easy way to import data from Excel 3. It will then display data through some reporting tool. Is there a good SQLite-based alternative to LibreOffice Base? I found this: http://sqlitestudio.pl http://www.valentina-db.com http://www.navicat.com/products/navicat-for-sqlite Thank you. Not exactly "lite" in size, but kexi does have most of the features of Access and uses sqlite to store its data: http://kexi-project.org/ David ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Windows user app to display input form + reporting?
On 12 Mar 2014, at 11:00am, Gilles Ganault wrote: > I see that the wiki contains no document about GUIs: > www.sqlite.org/docs.html Because they're not SQLite. SQLite is the SQLite API, which is written for programmers to use. That's what the SQLite web site is about. If someone wants to write an app that uses SQLite they can put up their own web site. Any GUI you see is provided by a third party. There's no point in trying to keep track of more than a hundred database management GUIs, many of which are buggy, many of which interface with other database systems as well as SQLite. The only result that would have is that if there is a bug in one of those apps, someone would think the SQLite team is responsible, and word would get passed around that SQLite is buggy. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Windows user app to display input form + reporting?
On Wed, 12 Mar 2014 10:29:43 +0100, Kees Nuyt wrote: >Not what you asked for, but LibreOffice Base can use SQLite via ODBC: > >http://ch-werner.de/sqliteodbc/ > >I have no experience with that solution, but at least the package is >maintained and reasonably up to date. Thanks guys. In addition, there's this tool: www.rifin.co.za/software/sqlc/ I see that the wiki contains no document about GUIs: www.sqlite.org/docs.html Can non-admin users contribute to the wiki, so that users don't have to ask in the mailing list? Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Windows user app to display input form + reporting?
On Wed, 12 Mar 2014 00:31:03 +0100, Gilles Ganault wrote: >Hello > > A friend needs to move from Excel to a database. The school won't > pay for the full version of MS Office that includes Access, so > recommended that she use LibreOffice Base instead. > > I just checked it out, and it seems to only be a front-end to the > HSQLDB database which is written in Java. > > Before I check it out, I'd like to make sure there's no SQLite-based > lighter solution where... > 1. I'll run the commands originally to build the DB + tables > 2. The Windows application will either display forms for her to enter > data, or provide an easy way to import data from Excel > 3. It will then display data through some reporting tool. > > Is there a good SQLite-based alternative to LibreOffice Base? > > I found this: > http://sqlitestudio.pl > http://www.valentina-db.com > http://www.navicat.com/products/navicat-for-sqlite Not what you asked for, but LibreOffice Base can use SQLite via ODBC: http://ch-werner.de/sqliteodbc/ I have no experience with that solution, but at least the package is maintained and reasonably up to date. HTH -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Windows user app to display input form + reporting?
SQLite Expert has a free version that can be used. Certain UI features are missing, but, it does allow for excel like table editing. Its also MUCH cheaper than anything Microsoft has put out, even with their "dealer discounts" and "oem" sales with proper hardware purchases. On Tue, Mar 11, 2014 at 7:31 PM, Gilles Ganault wrote: > Hello > > A friend needs to move from Excel to a database. The school won't > pay for the full version of MS Office that includes Access, so > recommended that she use LibreOffice Base instead. > > I just checked it out, and it seems to only be a front-end to the > HSQLDB database which is written in Java. > > Before I check it out, I'd like to make sure there's no SQLite-based > lighter solution where... > 1. I'll run the commands originally to build the DB + tables > 2. The Windows application will either display forms for her to enter > data, or provide an easy way to import data from Excel > 3. It will then display data through some reporting tool. > > Is there a good SQLite-based alternative to LibreOffice Base? > > I found this: > http://sqlitestudio.pl > http://www.valentina-db.com > http://www.navicat.com/products/navicat-for-sqlite > > Thank you. > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Windows user app to display input form + reporting?
Hello A friend needs to move from Excel to a database. The school won't pay for the full version of MS Office that includes Access, so recommended that she use LibreOffice Base instead. I just checked it out, and it seems to only be a front-end to the HSQLDB database which is written in Java. Before I check it out, I'd like to make sure there's no SQLite-based lighter solution where... 1. I'll run the commands originally to build the DB + tables 2. The Windows application will either display forms for her to enter data, or provide an easy way to import data from Excel 3. It will then display data through some reporting tool. Is there a good SQLite-based alternative to LibreOffice Base? I found this: http://sqlitestudio.pl http://www.valentina-db.com http://www.navicat.com/products/navicat-for-sqlite Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users