[kwlug-disc] open office question.

[Joe Wennechuk]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://kwlug.org/pipermail/kwlug-disc_kwlug.org/attachments/20090909/b632f2bb/attachment.htm>