Thanks guys. I've had 40 votes so far on my blog's poll:
http://blog.jooq.org/2012/04/12/which-database-are-you-using-jooq-with/
This is the current result:
----------------------------------------
create.select(
denseRank().over().orderBy(*POLL.**VOTES*.desc()),
*POLL.**VOTES*
.mul(100)
.div(sum(*POLL.**VOTES*).over())
.concat(" %")
.lpad(4, ' ').as("percent"),
*POLL.DIALECT*)
.from(*POLL*)
.orderBy(*POLL.VOTES*.desc())
.fetch();
----------------------------------------
*Outcome (with 6 clear winners so far):*
+----------+-------+-------------------+
|dense_rank|percent|dialect |
+----------+-------+-------------------+
*| 1|22 % |MySQL |
| 1|22 % |Oracle |
| 2|15 % |Postgres |
| 2|15 % |H2 |
| 3|10 % |SQLServer |
| 4| 7 % |HSQLDB |
*| 5| 2 % |Other |
| 5| 2 % |DB2 |
| 5| 2 % |Derby |
| 6| 0 % |SQLite |
| 6| 0 % |Ingres |
| 6| 0 % |Sybase SQL Anywhere|
| 6| 0 % |Sybase ASE |
| 6| 0 % |CUBRID |
+----------+-------+-------------------+
Am Donnerstag, 12. April 2012 18:41:59 UTC+2 schrieb Lukas Eder:
>
> Dear jOOQ users,
>
> Please participate in this poll:
> http://blog.jooq.org/2012/04/12/which-database-are-you-using-jooq-with/
>
> In order to focus more on the real needs of jOOQ users, I'd like to
> know which are your favourite databases
>
> Cheers
> Lukas
>
>
