pgjdbc
mssql-jdbc
| pgjdbc | mssql-jdbc | |
|---|---|---|
| 14 | 7 | |
| 1,421 | 1,026 | |
| 0.9% | 1.0% | |
| 9.3 | 8.9 | |
| 1 day ago | 7 days ago | |
| Java | Java | |
| BSD 2-clause "Simplified" License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pgjdbc
-
Password may not contain: select, insert, update, delete, drop
The method doAppendEscapeLiteral (Line 66) is a good example; https://github.com/pgjdbc/pgjdbc/blob/master/pgjdbc/src/main...
I didn’t take notes all the way down, but at the end of the day this method is invoked when a prepared statements’ parameters are being bound
-
Everything People Don't Get About CVEs
Let's take CVE-2022-21724 which has a base score of 9.8 - Critical from NVD. This vulnerability has the following description on GitHub link:
- For daily Java programmers: after almost one decade of Java 8, are streams and lambdas fully adopted by the Java community?
-
KTor and non-blocking sql
Virtual threads are great but db drivers still have to tweak (mainly to remove synchronized I/O) to be compatible with loom. Postgres just recently merged the changes for loom https://github.com/pgjdbc/pgjdbc/issues/1951
-
loom and database drivers
You can see it for example in the Postgres driver here or the MS SQL driver here. Oracle of course has already released their driver as Loom ready.
- Embracing Virtual Threads with Spring
-
Java 19
See here for details, one of the Project Loom mainainers chimes in with the bad news -- looks like a Loom supported solution is a ways off, so rewriting library/application code that uses synchronized is the only way to actually benefit from Loom's virtual threads.
-
Why is Spring so slow in TechEmpower benchmark?
Any chance you could add a thought / opinion to https://github.com/pgjdbc/pgjdbc/issues/1951 ? Around synchronized & ReentrantLock etc. Any input would be greatly appreciated.
-
I feel like this should be in every model, class and function just to be sure.
This is about types defined outside your business and that means you possibly don't have a chance to do better, e.g. PgPreparedStatement from PostreSQL driver.
- Postgres Java lib returns wrong numeric value after 5 reads
mssql-jdbc
-
loom and database drivers
You can see it for example in the Postgres driver here or the MS SQL driver here. Oracle of course has already released their driver as Loom ready.
- Class.getRecordComponents surprisingly slow
-
mssql-jdbc finally supports different prepare modes
I'm not apologizing. Just pointing out where to put the blame see the discussion here https://github.com/microsoft/mssql-jdbc/issues/245
-
5 Mundane Java Performance Tips
I've seen this one as a performance/allocation bottleneck quiet frequently (even filed a bug on this to the MS SQL Server Driver, https://github.com/microsoft/mssql-jdbc/issues/1051 )
-
Working Around a Case Where the Postgres Planner Is “Not Smart”
The other thing i'm currently struggling with is the slow parameter sniffing in SQL server. We would really like to switch to the official mssql-jdbc driver but the performance is abysmal:
https://github.com/microsoft/mssql-jdbc/issues/1196#issuecom...
jtds "avoids" this problem as it doesn't use prepexec.
-
Why you should disable sendStringParametersAsUnicode when using the SQL Server JDBC Driver
You should probably also disable sendTimeAsDatetime see #1007
What are some alternatives?
pgjdbc-ng - A new JDBC driver for PostgreSQL aimed at supporting the advanced features of JDBC and Postgres
postgres - Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see http://wiki.postgresql.org/wiki/Submitting_a_Patch
HikariCP - 光 HikariCP・A solid, high-performance, JDBC connection pool at last.
Ebean ORM - Ebean ORM
Trino - Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
jOOQ - jOOQ is the best way to write SQL in Java
zgc - The Z Garbage Collector https://wiki.openjdk.org/display/zgc
H2 - H2 is an embeddable RDBMS written in Java.
requery - requery - modern SQL based query & persistence for Java / Kotlin / Android
avaje-inject - Dependency injection via APT (source code generation) ala "Server-Side Dagger DI"