Raymond, On Thu, 2011-08-25 at 20:27 +0200, L O wrote:
> I am surprised that Base is not a database program. I thought it was meant > to be something like MS Access? Why is it included then in Libre Office? > > I am also trying to create a database in Base (as I did before in Access), > however I also run into problems I never had when using Access... > > Raymond > I recommend MySQL/MariaDB for a back-end. You connect to the back-end not the default back-end (HSQL). MySQL/MariaDB are mature databases. There are others which are also mature and will make an excellent back-end, I have not tried some of them yet. The advantage of this method is that you can use the Base front-end to set up, manage the database with users having access to the same database. > > From: Andreas Säger <[email protected]> > To: [email protected] > Date: 25-08-2011 10:28 > Subject: [libreoffice-users] Re: Writing programs for Base > > > > Since Base is not a database program, the first thing to know would be the > actual database to be used. An embedded HSQLDB is only one option, good > enough for simple demos and drafts but you don't really want to develop > anything serious for that. > > Every "common database" (MySQL, Postgre,... and HSQLDB too) provides > access > to external text tables by means of database structures pulling their > content from plain text files. > You can create a view which selects the wanted records from the text table > in the right order of columns. > In Base you can drag or copy the view icon over the target table's icon > and > hit "Create". > A set of example files dealing with csv, Base and Calc: > http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=23727 > [Example] Loading CSV into preformatted spreadsheets > Files #1 and #2 resemble a text file linked to a (embedded) HSQLDB, > editable > through an input form on a (embedded) Writer document. > > Using some "common database", any "common scripting language" can update > the > database with very few lines of code. No 350MB office suite required for > that. > > > -- > View this message in context: > http://nabble.documentfoundation.org/Writing-programs-for-Base-tp3283165p3283334.html > > Sent from the Users mailing list archive at Nabble.com. > > -- > For unsubscribe instructions e-mail to: [email protected] > 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 > > > -- Jay Lozier [email protected] -- For unsubscribe instructions e-mail to: [email protected] 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
