Re: [libreoffice-users] Re: Writing programs for Base

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<msmickelsen@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-424438@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
jslozier@gmail.com

-- 
For unsubscribe instructions e-mail to: users+help@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