[kwlug-disc] open office question.

[R. Brent Clements]

For your own purposes then what you are proposing seems like a good
candidate for Base.  If the output of these queries is for a larger
project (web based or part of a large distributed software suite),
then you may want to use a more seasoned DB engine.  One thing that
you may not have noticed is that you can design a query in Base, then
click the SQL view and see it written in command format that should be
compatable with other SQL databases with the same table structure.  So
it is an excellent learning tool.

I wish I could be more help.  I used a MySQL user guide to learn the
basics of SQL queries, but have very little practical knowledge in
actually setting up a DB, tho I have been working toward an index of
my DJ music collection using Base, and I have run into some issues.

Brent

On Wed, Sep 9, 2009 at 11:23 AM, Joe
Wennechuk<youcanreachmehere at hotmail.com> wrote:
>
> Can you suggest something for me? I am trying to write a database to keep my
> feed info for a google transit feed. The data set isn't going to change too
> much, but I am going to run a lot of querys. I would like to use a GUI
> similar to MSSQL SSMS.
>
> I don't have enough experience with MySQL to write the statements by hand
> without alot of digging.
>
>
> Joseph Wennechuk
> ________________
>
>
>
>
>> Date: Tue, 8 Sep 2009 11:22:27 -0400
>> From: rbclemen at gmail.com
>> To: kwlug-disc at kwlug.org
>> Subject: Re: [kwlug-disc] open office question.
>>
>> I have a little bit of experience with Base. It is not without
>> problems (at least in the 2.x series--3 may be a bit better. I have
>> yet to test most of it.)
>>
>> Formatting of data entry seemed problematic to me. I ended up having
>> to enter time in the hh:mm:ss format when the hour was redundant. The
>> output could be formatted back the way I wanted without too much
>> trouble.
>>
>> As for field descriptions, I have no problems in 3.x, don't remember
>> noticing them in 2.x either. The only saving problem I had was not
>> realizing that it hadn't saved because I didn't read the popup that
>> told me about the missing primary key.
>>
>> Also, I assume that you are using the internal local-file DB engine in
>> Base. It is possible to get it working as a frontend for any DB that
>> supports ODBC or JDBC (I think) but it requires extra work and some
>> additional packages, and I have never done that. If you have
>> installed this system then the problem may be related to what Base is
>> capable of saving in the external DB.
>>
>> Not convinced that Base on its own is ready for mission critical
>> deployments yet, but I have only scratched the surface, and I don't
>> have any formal experience with databases.
>>
>> Brent
>>
>> On Mon, Sep 7, 2009 at 6:13 PM, Joe
>> Wennechuk<youcanreachmehere at hotmail.com> wrote:
>> > I am making some tables for an open office base project. As I go through
>> > and
>> > enter descriptions and set data types, etc everything looks okay. As
>> > soon as
>> > I hit the save button for the table all of the descriptions go bye bye
>> > except one, and some of the formatting is lost also. I dont have much
>> > experience with base, and I don't want to do this a fourth time unless I
>> > know its going to work. Is base good? I'm doing a project with the
>> > google
>> > transit api? Will base work well for a small database?
>> >
>> > Joseph Wennechuk
>> > ________________
>> >
>> >
>> >
>> > _______________________________________________
>> > kwlug-disc_kwlug.org mailing list
>> > kwlug-disc_kwlug.org at kwlug.org
>> > http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org
>> >
>> >
>>
>> _______________________________________________
>> kwlug-disc_kwlug.org mailing list
>> kwlug-disc_kwlug.org at kwlug.org
>> http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org
>
> _______________________________________________
> kwlug-disc_kwlug.org mailing list
> kwlug-disc_kwlug.org at kwlug.org
> http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org
>
>