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 <jengab@elte.hu 
> <mailto:jengab@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