Path: csiph.com!news.redatomik.org!aioe.org!.POSTED!not-for-mail
From: =?UTF-8?Q?Arne_Vajh=c3=b8j?= <arne@vajhoej.dk>
Newsgroups: comp.lang.java.programmer
Subject: Re: Which databases are the most used with Java
Date: Sun, 13 Aug 2017 16:59:20 -0400
Organization: Aioe.org NNTP Server
Lines: 40
Message-ID: <omqej6$1mhd$1@gioia.aioe.org>
References: <87y3qovwjb.fsf@munus.decebal.nl>
NNTP-Posting-Host: 5VufzpQaY1AiVRqLF21lbg.user.gioia.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Complaints-To: abuse@aioe.org
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Thunderbird/45.8.0
X-Notice: Filtered by postfilter v. 0.8.2
Xref: csiph.com comp.lang.java.programmer:37202

On 8/13/2017 1:58 AM, Cecil Westerhof wrote:
> I am making a wrapper around JDBC. I myself only use SQLite3 (at the
> moment), but I want to share it. Then I should implement (at least)
> the most important databases. I am thinking that the following
> probably are used a lot:
>     SQlite
>     MySQL
>     MariaDB
>     PostgreSQL
>     Oracle
>     SQLServer
>     DB2
>     H2
>     Derby
>     HyperSQL
>
> I should -I think- at least write an implementation for those. I am
> using Linux, but I understood that nowadays you can run SQLServer on
> Linux. So it should be doable.
>
> Are there any other database that I ‘should’ implement?

The question about whether to implement something for each database
has already been discussed extensively, so I will only comment on the
question in the subject.

It is my subjective impression that:
* Oracle and DB2 are used in production by many Java sites
* MySQL/MariaDB and PostgreSQL are used in production by some Java sites
* SQLServer is used in production by few Java sites
* "small" databases like SQLite, H2 and Derby usually in embedded mode
   are used for:
   - development
   - for Java SE applications that need flexible local storage

Arne