Re: [Libreoffice] testing databases
Well, naturally it isn't a virtual machine with already set up DB systems can be useful, however for me it cause no problem to set up a database, as for MySQL it only needs some basic SQL knowledge and the using of apt/synaptic. But for example an Oracle server is much more difficult to configure, it even needs an own oracle system user who will be the database administrator. But in general all database systems should be more or less equal, as they all use SQL, unfortunatelly there are such differences as HSQL- Oracle(also MySQL), in HSQL you need to write table names like: Table1 in Oracle you can do it just saying table1 or even Table1 as SQL is originally not case sensitive except for string constants. In HSQL I even noted that there is no C-like /* */ comment, if I am not wrong it exists in Oracle, however Oracle is a quite extended SQL language, it contains an own programming language called PL/SQL. 2011. 09. 02. 12:09 keltezéssel, Caolán McNamara írta: On Thu, 2011-09-01 at 22:08 +0200, Jenei Gábor wrote: How can I quickly setup a database and query to test this thing? I find setting up databases and configuring them a super pain in the ass, so much so that I have a fair number of bugs lingering because I can't motivate myself to struggle with configuring databases. Personally, I think I would be tempted by something like a virtual box VDI pre-configured, installed and populated databases images/appliances Is this a stupid idea ? C. ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
Re: [Libreoffice] testing databases
Yes, but still it is much more complicated to configure on server side, however I admit that it has much more functions also, by the way I used it in database courses also, it's a quite widely used database system, but I don't think it worth the time if you just plan a simple php page with database access, for this purpose MySQL is better, as it is easy to install (you just push a button and it's on your computer, after this you only have to know SQL Table creating commands) Gabor 2011. 09. 02. 12:37 keltezéssel, Jonathan Aquilina írta: Jeni you mention oracle being more difficult to configure, In my database course last year we used an online oracle database, Its free to use and you must ensure no private or real sensative data is used to populate the database. Not sure if this would be of any use http://apex.oracle.com its free to use and to work with. On Fri, Sep 2, 2011 at 12:33 PM, Jenei Gábor jen...@elte.hu mailto:jen...@elte.hu wrote: Well, naturally it isn't a virtual machine with already set up DB systems can be useful, however for me it cause no problem to set up a database, as for MySQL it only needs some basic SQL knowledge and the using of apt/synaptic. But for example an Oracle server is much more difficult to configure, it even needs an own oracle system user who will be the database administrator. But in general all database systems should be more or less equal, as they all use SQL, unfortunatelly there are such differences as HSQL- Oracle(also MySQL), in HSQL you need to write table names like: Table1 in Oracle you can do it just saying table1 or even Table1 as SQL is originally not case sensitive except for string constants. In HSQL I even noted that there is no C-like /* */ comment, if I am not wrong it exists in Oracle, however Oracle is a quite extended SQL language, it contains an own programming language called PL/SQL. 2011. 09. 02. 12:09 keltezéssel, Caolán McNamara írta: On Thu, 2011-09-01 at 22:08 +0200, Jenei Gábor wrote: How can I quickly setup a database and query to test this thing? I find setting up databases and configuring them a super pain in the ass, so much so that I have a fair number of bugs lingering because I can't motivate myself to struggle with configuring databases. Personally, I think I would be tempted by something like a virtual box VDI pre-configured, installed and populated databases images/appliances Is this a stupid idea ? C. ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org mailto:LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice -- Jonathan Aquilina ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
Re: [Libreoffice] testing databases
Hi Caolán, On Friday, 2011-09-02 11:09:37 +0100, Caolán McNamara wrote: How can I quickly setup a database and query to test this thing? I find setting up databases and configuring them a super pain in the ass, so much so that I have a fair number of bugs lingering because I can't motivate myself to struggle with configuring databases. Personally, I think I would be tempted by something like a virtual box VDI pre-configured, installed and populated databases images/appliances At least for the simple tasks like this, running some SQL query against any database, the ODBC/HSQL (or whatever is the background job doing) of Base is sufficient. The easiest method (of course I had to have that idea after having created my own ;) is probably to copy (to not mess around with the registered sample database) install/basis3.5/presets/database/biblio.odb to the document folder and file open it. Is this a stupid idea ? If larger SQL systems setup in specific ways are needed, a VB is probably a good idea. Eike -- PGP/OpenPGP/GnuPG encrypted mail preferred in all private communication. Key ID: 0x293C05FD - 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD signature.asc Description: Digital signature ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice