[OT] Re: For Windows platform: which Dia plugin or App to simplify design and documentation of small Database Applications ?
Le 27/10/2012 02:40, Andrey Repin a écrit : Greetings, Paul Smith! @ 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). Greetings Paul, this discussion is largely off-topics here, but your initial question was how to design a /simple/ database. In order to, with Dia you must use for UML sheet, with classes and relations between, then specific scripts (I guess they are numerous now) in order to generate DDL from Dia file. I'ts a long time I didn't use and I can't remain the whole, but as far as I know properties has 2 parts, and if I remain correctly in the second were placed foreign keys and constraints. You could find convenient information on that docs scripts themselves :) About SQL servers, hardware requirements depends essentially on how large are the data and how complex is the database (also for MySQL you can use table which do not handle relational (FK) model at all). As said, you can tune MySQL and designed databases for a small footprint, while you'll loose even "relational" in some cases. If databases are fairly large and complex, PostgreSQL is the better choice, offering advanced models, also numerous languages (for stored procedures and triggers), and it occupies what it really needs, and numerous connectors (including odbc, unsure of jdbc). MS SQL is a fork from initial Postgres branch (have been given also Ingres, which AFAIK turned back Free Software), then... years ago, MS SQL main engineer said "we failed" (about what some queries /should/ returns). Hardware requirements are simply huge regarding db contents. What I know of Oracle it is: you need a database engineer (doing select bluk from V$database where... n times with n V$ tables / fields just to get schema is stupid, also I heard tablespaces can grows now automatically but... this is just a sample of the nightmare what you'll get). Last but not least : it is proprietary, there is a restricted "free beer" version, but costs are simply astronomical. There are also "appliances SQL databases engines" such as libraries, but you'll need to implement anything else by program, and they are intended for "standalone" appliances. Last, I'm quite surprised how big is a needed machine to run a simple server with Windows as OS :) Best Regards, TSFH ___ 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
Your software Dia
Dear developers, I am writing you regarding your software Dia. This is Ronny Gey and I am the admin of the website http://www.sosciso.de - Social Science Software. I added your software in our database and would like to inform you with this mail. Please, see here the details on your software: http://www.sosciso.de/en/software/ubersicht/?wctsort=lizenz&wctstart=1&&wcteid=44 If you have further questions, please feel free to contact me. Best regards, Ronny Gey -- [SoSciSo] [http://www.sosciso.de] [:de] Der Blog zu Software im sozialwissenschaftlichen Forschungsprozess [:en] The blog about software in the social science research process ___ 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
Re: Your software Dia
Le 26/10/2012 20:14, edi...@sosciso.de a écrit : Dear developers, I am writing you regarding your software Dia. This is Ronny Gey and I am the admin of the website http://www.sosciso.de - Social Science Software. I added your software in our database and would like to inform you with this mail. Please, see here the details on your software: http://www.sosciso.de/en/software/ubersicht/?wctsort=lizenz&wctstart=1&&wcteid=44 If you have further questions, please feel free to contact me. Hi, I'm not a Dia developer, but did given an eye on your software list and "details" 1) my English is far from perfect, but I can't handle German at all :) 2) you display a screenshot, which is good, but I can't find "scope of usage", even if first line could say "diagram authoring". What could be really interesting would have "capabilities" listed, then "usability" etc, "rated" (eg by stars or score n/10) Your table is a good idea, I suppose there are numerous ones, to scope on scientific engineering will reduce public but you'll get an accurate one. Regards, TSFH ___ 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
For Windows platform: which Dia plugin or App to simplify design and documentation of small Database Applications ?
@Michael Ross Thanks for your help. My initial post on 23/10 said I had selected HSQLDB as the target RDBMS. In response to my question "*I am looking for a tool to simplify design and documentation of small* *> Database Applications, ideally starting creation of the ER Diagram, from* *> which the SQL DDL is generated to create the tables in the target RDBMS* ." Andre replied: What about MySQL Workbench? Until then I assumed from the name it supported MySQL only, but then looked up MySQL WB in Wikipedia and read that from ver 5.2.41 released only 3 months ago, it supported a few other RDBMS, and 'any ODBC compliant db', Delving further, I read its minimum hardware requirement stated as more powerful than my Nettop, and a review dated 2009 run on a laptop with 2.5GHz CPU said WB was 'dog slow but best there is'. (a comment said its fast on Mac, slow on PC) Spent a while perusing the WB User Manual and saw no mention of HSQLDB. That was the reason I asked if WB was worth persuing further. *If it won't run on my platform, or I am mistaken in thinking WB supports ERD-to-SQL for HSQLDB, then its a red herring for me*. @Andre As per my reply above, I don't think I am confusing a RDBMS with a "*a tool to simplify design and documentation of small Database Applications*", although as Michael seems to think I was asking about the MySQL RDBMS as opposed to the MySQL WB you suggested I might consider, maybe the rest of my post should have been clearer, or, it may be MySQL WB still does only support MySQL RDBMS, hence Michael assuming I was interested in MySQL RDBMS. As stated in my last post, when looking for a (Open Source) DB Engine for my (low-powered) platform, I had ruled out MySQL for the reasons given. It was some time back I searched for comparisons of Open Source RDBMS engines, and seemed to remember reading somewhere MySQL also needed meatier HW than I have. You ask what type of configuration. I didn't mention it as didn't think it mattered in context of 'tool to simplify design...', but my project is limited to non-web standalone db on single-user nettop. Thanks for your insight on MySQL anyway. Interesting your MySQL Server runs on 850MHz Athlon with 512Mb RAM. *Does it also run WB ?* As WB support for 'any ODBC compliant db' was only added 3 months ago - *is that why you suggested I consider WB ?* @Thomas Harding Thanks for your input. The Tutorial in Steffan's link gave a clear guide how to get started using UML - except the links to the tutorial dia & sql files are broken. Its just that UML seems overly complex compared to the far simpler Chen notation of 1:1, 1:n, m:n notation, that I found perfectly sufficient in the past. Also, my last reply asked if, rather than all users having to 'reinvent the wheel', are there not predefined 'typemap' files supporting all relevant features of target DB, in this case HSQLDB, users can download ? You recommend Postgres as a better engine. Having read articles comparing the candidates, that was my first choice (I was impressed with the User Manual), but I read it requires more powerful hardware than I have and has good community help, so HSQLDB was 2nd choice. My project is small, about 20 tables, and for the Forward Engineering, need contain just small sample data, so it may not place much load on any ERD design tool. ___ 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
