Paul, It has been 5 years since I used MySQL , but I know some general things about it. You can drop back to earlier versions if you need to. I started out using v4 and I found to be quite fast for numeric data. You could throw a million numbers in and out of it with no problem. If the 2 core 1.6GHz W7 etc. limits are really important then an earlier version would be a solution.
For decades MySQL has been a back bone of the web. It is very capable. I never got much help from the "community," but it was simple enough for my novice needs. On Fri, Oct 26, 2012 at 3:39 AM, Paul Smith <paul.smithy...@gmail.com>wrote: > @ Andrey > Thank you for your suggestion of MySQL Workbench. Interesting lead. With > MySQL in the name I had assumed not worth investigating for use with HSQLDB > (when choosing a RDBMS I was looking for one adhering closely to SQL > standards and suitable for a low power platform such as a nettop, so I > rejected MySQL as read it was not very compliant, also the Oracle takeover > sounds bad news for it). However I see the Wiki states *from ver 5.2.41*it > adds support for a few other specific RDBMS, and generically for any > ODBC connection. > Spent half an hour skimming the User Manual - which seems quite impressive > at 466 pages. Googling also brings up many other PDF's on use (with MySQL) > I have 2 concerns before delving further: the Manual states hardware > requirments are 2-core 2GHz + 4GB RAM. My HW is 2-core 1.6GHz + 2GB RAM, > FHD Monitor, Win7 32bit. CalEvens.com review of Community Edition in 2009 > states *'its dog slow but best there is*'. * Is todays Windows version > faster or slower ?* Secondly, the Manual makes no mention of HSQL > support - only 'any ODBC compliant db'.... being new to server/client, do > you know if its likely to 'simplify design and documentation of small [20 > table HSQLDB] Database Applications' ? > > @ Steffen > Thank you for pointing me to that clear and well-written introductory > tutorial. To cut evaluation time, I would like to download the .dia, .sql > files used in his tutorial and run them on my nettop using the tool you > recommend - but alas his links are dead. Do you know where I can obtain > the 3 files, or if not, an equivalent .dia/.sql set ? A matter in his > tutorial of concern, is to configure the tool to use the syntax of the > target RDBMS, you need a 'typemap' file in order to use all the > functionality of the target, but only shows how to create it. Thats fine > if the wheel hasnt been invented, but surely the 'typemap' needs many > entries to support all relevant features of each target DB ? Are there not > predefined 'typemap' files supporting all relevant features of target DB, > in this case HSQLDB, users can download ? > > Lastly, you ask if this is what I'm looking for. Not sure... Ideally, I > was looking for a dia 'plugin' that hopefully adds at the simplest level, > say 3 buttons: <Select Plugin> (HSQLDB), <Validate [ERD] Model>, and <Make > SQL>. > > I thank you both for your assistance. > > > _______________________________________________ > dia-list mailing list > dia-list@gnome.org > https://mail.gnome.org/mailman/listinfo/dia-list > FAQ at http://live.gnome.org/Dia/Faq > Main page at http://live.gnome.org/Dia > > > -- Put this question to yourself: should I use everyone else to attain happiness, or should I help others gain happiness? *Dalai Lama * To invent, you need a good imagination and a pile of junk. Thomas A. Edison<http://www.brainyquote.com/quotes/quotes/t/thomasaed125362.html> A public-opinion poll is no substitute for thought. *Warren Buffet* Michael E. Ross (919) 550-2430 Land (919) 576-0824 <https://www.google.com/voice/b/0?pli=1#phones> Google Phone (919) 631-1451 Cell (919) 513-0418 Desk michael.e.r...@gmail.com <michael.e.r...@gmail.com>
_______________________________________________ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia
