Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.