I have recently started an enquiry about which databases jOOQ users are most frequently using. The poll is here:
https://blog.jooq.org/which-database-are-you-using-jooq-with/
Of course, such a poll is best analysed using jOOQ’s OLAP features. When dumped into a POLL table in our database, we can query the database for the ranking as such:
System.out.println(
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());
And the winners after 40 votes are:
+----------+-------+-------------------+
|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 |
+----------+-------+-------------------+
Like this:
Like Loading...
Published by lukaseder
I made jOOQ
View all posts by lukaseder
