pgjdbc
pgjdbc-ng
| pgjdbc | pgjdbc-ng | |
|---|---|---|
| 14 | 1 | |
| 1,421 | 592 | |
| 0.9% | 0.0% | |
| 9.3 | 0.0 | |
| 1 day ago | about 2 months ago | |
| Java | Java | |
| BSD 2-clause "Simplified" License | GNU General Public License v3.0 or later |
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
pgjdbc-ng
-
Postgres query execution: JDBC
The purists will point out that JDBC is not a product but a standard. And indeed, outside of the official postgres driver "PGJDBC" there are other drivers, such as PGJDBC-NG.
What are some alternatives?
HikariCP - 光 HikariCP・A solid, high-performance, JDBC connection pool at last.
Hibernate - Hibernate's core Object/Relational Mapping functionality
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
aceql-http-client-jdbc-driver - Java JDBC Driver for easy access of remote SQL databases managed with AceQL HTTP
zgc - The Z Garbage Collector https://wiki.openjdk.org/display/zgc
crate-jdbc - A JDBC driver for CrateDB.
H2 - H2 is an embeddable RDBMS written in Java.
requery - requery - modern SQL based query & persistence for Java / Kotlin / Android