Connecting to Databases with Python jaydebeapi: A Comprehensive Guide
Learn how to connect to databases using Python's jaydebeapi library. This powerful tool bridges Python with Java Database Connectivity (JDBC), enabling access to various databases like MySQL and Oracle. Perfect for when native Python drivers aren't available. #Python #Databases #Jaydebeapi #JDBC #MySQL #Oracle
https://tech-champion.com/programming/connecting-to-databases-with-python-jaydebeapi-a-comprehensive-guide/
...

Spark JDBC Connection To MsSQL Using Kerberos - Failed to find any Kerberos tgt https://stackoverflow.com/questions/79500919/spark-jdbc-connection-to-mssql-using-kerberos-failed-to-find-any-kerberos-tgt #sql-server #apache #spark #pyspark #jdbc #kerberos

Connecting to Databases with Python jaydebeapi: A Comprehensive Guide
Learn how to connect to databases using Python's jaydebeapi library. This powerful tool bridges Python with Java Database Connectivity (JDBC), enabling access to various databases like MySQL and Oracle. Perfect for when native Python drivers aren't available. #Python #Databases #Jaydebeapi #JDBC #MySQL #Oracle
https://tech-champion.com/programming/connecting-to-databases-with-python-jaydebeapi-a-comprehensive-guide/
...

Today I created a #Flyway plugin for #neo4j using our #JDBC driver

https://github.com/michael-simons/neo4j-flyway-database

But Michael, aren't you the main author of Neo4j-Migrations?

I sure am and both the latter and the new plugin create the same meta-graph for the migrations and are mostly compatible.

This is really cool and kinda insane—running modern #Perl on the #Java Virtual Machine (#JVM).

Why? Maybe you want the flexibility of Perl scripts in your JVM-based environment (including #Kotlin and #Scala) without shelling out. More reasons here: https://github.com/fglock/PerlOnJava/blob/master/docs/WHY_PERLONJAVA.md

Anything with #XS or #FFI C code has to be ported to Java, mind you. But @fglock has been doing just that, e.g., #DBI support via #JDBC and #JSON via fastjson2.

https://mastodon.social/@fglock/113034902296008665

Boom!

The OpenLink Software #AI Layer (#OPAL) now supports AnthropicAI's #Claude language models.

See comments for a #DataTwingler AI Agent demo executing #SPARQL and #SQL queries via a live #VirtuosoRDBMS instance.

Remember, query scope is SPARQL, #ODBC, or #JDBC accessible data sources.

Virtuoso Open Source (VOS) 7.2.14 is out!

Our high-performance, multi-model #VirtuosoRDBMS supports:

• Relational tables & graphs
• #SQL, #SPARQL & #GraphQL
• Seamless AI integration w/ #LangChain & #LlamaIndex via #HTTP, #ODBC, or #JDBC

Read on for links etc..

FYI: Ich werde die kommende Woche-am Mittwoch 6.11-auf der #WJAX
in München über den neuen #Neo4j #JDBC #Java Connector, #SQL zu #Cypher Übersetzung und irgendwas mit #AI sprechen. Vielleicht sehen wir uns auf dem hallway-Track.

cursor_tuple_fraction and the #PostgreSQL #JDBC driver https://www.cybertec-postgresql.com/en/cursor_tuple_fraction-in-postgresql-jdbc/

der bug gestern in der #sQLshell war gar nicht dort - in der bibliothek, die ich als Grundlage dafür erstellt habe existiert eine spezialisierte #wrapper implementierung eines #jdbc ResultSet, mit Typ (bis gerade eben) TYPE_FORWARD_ONLY und das #javaswing TableModel, das ich darum gestrickt hatte hat das schlicht ignoriert, wollte aber features eines Scrollable ResultSet nutzen und hat die daraus resultierenden Exceptions verschluckt. wid gefixt - betrifft die #sQLshell aber nicht direkt!

Damals bei der Spezifikation von #JDBC hätte man auch darauf achten können, den Implementierenden genauer vorzuschreiben, was sie wo in die Exceptions schreiben.

Beispiele Verletzung Unique Constraint

PG: sql state=23505 sql code=0
SQLite: sql state=null sql code=19

und überhaupt hätte man gleich Exceptions oder Codes für Standardfehler wie Unique Contraint Violation definieren können.

Wenn ihr also mal solche Standard APIs zu definieren habt, gebt den Implementierenden möglichst viel vor.

Eine Graph-Datenbank, eine 27 Jahre alte Spezifikation und GenAI gehen in eine Bar… (A graph-database, a 27 year old spec and GenAI walk into a bar)

2024 endlich noch mal auf der #JAX und werde über #Neo4j #JDBC und einen #RAG Usecase sprechen, den ich ganz cool finde…
Jep, ich bringe eine Liste mit kritischen Leseempfehlungen, nein, ich werd das ganze Zeug nicht hinter unnütz komplizierten Akronymen verstecken und ich freu mich sehr auf Diskussionen:

https://jax.de/big-data-machine-learning/genai-neo4j-rag/

I wonder if people which switched away from Hibernate to straight JDBC in a Micronaut Data context saw any performance degradation.

I guess this might depend on how Hibernate was being used, but I am about to do this and evaluate performance next week.

Parallel query in #PostgreSQL with #JDBC and DBeaver- CYBERTEC https://www.cybertec-postgresql.com/en/parallel-query-postgresql-problems-jdbc-dbeaver/

Be there or be square: Hosted by the #London #Java #Community my colleague Conor watson will be speaking about the brand new #Neo4j #JDBC driver next Thursday (April 25th).

https://www.meetup.com/londonjavacommunity/events/300068162/

I wrote about the new #JDBC #Driver for #Neo4j and sorry, it's on Medium… I cannot fix everything.

There's a bunch of cool stuff innit, among others the #SQL to #Cypher translation we build and the LLM based natural language to Cypher bits by @meistermeier

https://medium.com/neo4j/neo4j-jdbc-driver-version-6-22ca39be6647

I like the work I did on the #JDBC Driver for #Neo4j, which can do things like shown in the picture, and also will support chains of translation layers from "Something" to #Cypher

https://github.com/neo4j/neo4j-jdbc

c3p0 is a JDBC Connection pooling library I first published in 2002. It is very old-school, but i like to think it is still cool.

c3p0 v0.10.0 is the first major release — well, the first release at all — in a very long time. It now includes pluggable threading with loom support, much simplified connection testing by default, a more modern, more automated build, and many many fixes, improvements and enhancements.

https://github.com/swaldman/c3p0

https://www.mchange.com/projects/c3p0/

Hands-On with Catalogs in Flink SQL

In this second post in the series, @rmoff shows how to use Flink SQL with catalogs including #apacheHive, #JDBC, & #apacheIceberg. It also includes a closer look at the data structures within the Hive Metastore.

https://dcbl.link/flink-catalogs---2