Hi On Thu, 2011-08-25 at 15:19 -0400, webmaster for Kracked Press Productions wrote:
> To be honest, I have written a database program for a mainframe. I > really like the backend/frontend type. You can choose what database you > want to use that is best for your needs. MySQL seems to be the most > popular for the non-MS ones. Also is you do any Browser/server/web > based access to these databases, you should choose MySQL. > > The real part about databases is the way you access the data in the > system. Entry forms and Reports are the main stay for database > programmers. So it would be better to use the well-established backend > database systems and dedicate your office suite programming to access > packages for those popular systems. > > To be honest, would you want to use a database system that only one > package can access, or one that you can use for your office package > related documents and web-based access methods at the same time? Use LO > to do the entry and reports, and use HTML/browser based viewing for > those will low computer skills. It seems most offices now have HTML > based access to databases or other customer information. I think if you > have network based database access, that is the way to go. I would use > LO to do the initial work for setting up the database and the initial > data entry work, then use HTML/Browser based access for my users. Some > fields/records would require the admin/LO forms to do any edits to, as a > security feature though. > > SO it would make sense for LibreOffice to use the popular database > formats, like MySQL, and concentrate on the access forms/reports for > those bases. That is what I did for my Mainframe programming work, let > other define the database and I create the data entry and reports. Ubuntu provides connections for generic ODBC and specific connectors for MySQL, PostgreSQL and other databases to LO and other front-ends. I assume this is done in other Linux distros. I like using Base with MySQL/MariaDB because its connection is straightforward. > On 08/25/2011 02:37 PM, Tom Davies wrote: > > Hi :) > > Base is a front-end and yes you can easily choose which back-end you use. > > There > > are a lot of powerful back-ends out there. Base does have a default one but > > apparently it is better to choose something else. It is not in great shape > > right now but hopefully more people will help those that recently started > > rather > > than everyone building up their own front-ends that they then have problems > > maintaining and supporting adequately. Just my 2 cents/euros/pence. > > Regards from > > Tom :) > > > > > > > > > > ________________________________ > > From: mickelsen<msmickel...@gmail.com> > > To: users@global.libreoffice.org > > Sent: Thu, 25 August, 2011 19:21:58 > > Subject: [libreoffice-users] Re: Writing programs for Base > > > > I'm very surprised to learn that Base is not a database program. I > > guess it is just some sort of front end to "real" database programs, > > is that right? > > > > I guess this means that I'll have to get a real database program that > > I can write programs for in order to accomplish this project. Any > > suggestions as to what would be inexpensive and easy to work with? > > > > Thanks, > > Mark Mickelsen > > > > On Thu, Aug 25, 2011 at 2:28 AM, Andreas Säger [via Document > > Foundation Mail Archive] > > <ml-node+3283334-980602350-424...@n3.nabble.com> wrote: > >> 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: > >> [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. > >> > >> > >> ________________________________ > >> If you reply to this email, your message will be added to the discussion > >> below: > >> http://nabble.documentfoundation.org/Writing-programs-for-Base-tp3283165p3283334.html > >> l > >> To unsubscribe from Writing programs for Base, click here. > > > > -- > > View this message in context: > > http://nabble.documentfoundation.org/Writing-programs-for-Base-tp3283165p3284661.html > > > > Sent from the Users mailing list archive at Nabble.com. > > -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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