Re: [libreoffice-users] Base: Questions From Potential New User
Hi, From Base you can connect to your DB.. So no need to recreate anything. Base can be used to access the data in e.g. MySQL Liebe Grüße / Yours, Florian Reisinger Am 16.01.2015 um 17:00 schrieb Rich Shepard rshep...@appl-ecosys.com: Running LO-4.3.5 on Slackware-14.1. I am developing a database application to be used by unsophisticated users, all running some flavor of Windows. I've not before used Base so if I can it will make distribution easier than writing it in Python/wxPython and SQLite. I've read the Base handbook and have two questions for which I've not found answers. The schema has 18 tables (including many-to-many intermediate tables) and numerous foreign key references; more may be added. Will Base handle this many tables? The DDL text file (using sqlite syntax) is approximately 200 lines. Can this be imported into Base so I do not need to re-key each line to create the tables and relationships? TIA, Rich -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base: Questions From Potential New User
On Fri, 16 Jan 2015, Florian Reisinger wrote: From Base you can connect to your DB.. So no need to recreate anything. Base can be used to access the data in e.g. MySQL Florian, Yes, I read that. However, I do not see support for SQLite which is most appropriate for this application as it's a single-user, embedded rdbms. If I wanted a multi-user client-server rdbms I'd use postgres. Rich -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base: Questions From Potential New User
Rich , Florian is pointing in to the good direction, just connect LO base tot SQLite, google for Openoffice and SLQLite for some starting points Greetz Fernand On Fri, 16 Jan 2015, Florian Reisinger wrote: From Base you can connect to your DB.. So no need to recreate anything. Base can be used to access the data in e.g. MySQL Florian, Yes, I read that. However, I do not see support for SQLite which is most appropriate for this application as it's a single-user, embedded rdbms. If I wanted a multi-user client-server rdbms I'd use postgres. Rich -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base: Questions From Potential New User
On Fri, 16 Jan 2015, Fernand Vanrie wrote: Florian is pointing in to the good direction, just connect LO base tot SQLite, google for Openoffice and SLQLite for some starting points Fernand, Thank you, I'll do that. I did not see sqlite mentioned as supported in the handbook. Of course, the handbook is probably out of date. Regards, Rich -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted