[Libreoffice] testing databases

[Jenei Gábor]

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.
>
>