Continuing the series, @fritshoogland of #Yugabyte looks look into batching and how #Java #JDBC connections to #PostgreSQL work, so as to understand how to optimally implement them.

https://foojay.io/today/a-dissection-of-java-jdbc-to-postgresql-connections-part-2-batching

#foojaytip

The periodic Foojay :foojay: big overview, analysis, upcoming features and more, announcing the participation of @sonatype, #Yugabyte, #ChronicleSoftware, #OmniFishEE, and @Gradle!

Check it out here:
https://foojay.io/today/foojay-status-report-july-2023/

#foojaytip

It’s garbage day in many parts of Tampa, and it’s garbage night at Tampa Java User Group, where YugaByte’s Denis Magda’s talk is about apps leaving trash outside the heap and even outside the Java runtime. Be there and clean up your act!

#Java #JVM #database #datyabases #YugaByte #PostgreSQL #programming #meetup #Tampa #TampaBay

https://www.meetup.com/tampa-jug/events/292756241/

"Imagine you want to visit a city and have a specific budget. How should you spend the money and make your trip memorable? An excellent question to delegate to the #OpenAI engine." Denis Magda of #Yugabyte with #Java to the rescue!

https://foojay.io/today/creating-scalable-openai-gpt-applications-in-java

#foojaytip

"LSM-tree and block storage" by @fritshoogland #DEVCommunity https://dev.to/yugabyte/lsm-tree-and-block-storage-29ek #yugabyte #yugabyteDB

#yugabyte not fully Postgres compatible... so be careful. Looks like I have to abandon my second "lets use yugabyte instead for this packaged (opensource?) app".

psycopg2.errors.FeatureNotSupported: ALTER TYPE ADD ATTRIBUTE not supported yet

Until then...

Wants=chronyd.service
After=chronyd.service
ExecStartPre=+/usr/bin/chronyc waitsync

Will have to do #yugabyte

Basic, Conceptual Knowledge is Important!

I’ve recxently explored #postgresql and #yugabyte, notebly their "explain".

But before I want to share my (simple) findings, I want to establish some more basic groundwork first.
In general, we in the IT and RDBMS area tend do too much sexy-high-tech-stuff, and not enough basics and “common sense” thinking.

Start here...
http://pdvfirstblog.blogspot.com/2023/01/operating-and-diagnosing-rdbms.html

Continuing to part 2, https://twitter.com/denismagda creates a simple #Java application using a distributed #Yugabyte database to show whether it generates litter in response to application requests.

Check it out on Foojay :foojay: Today to find out more:

https://foojay.io/today/how-java-litters-beyond-the-heap-part-2-distributed-databases/

#foojaytip

Anyone interested in going the other way (scaling up) I think there might be something to the idea of having a docker-compose for swarm distributions that adds #minio for #s3 and #yugabyte as the #postgres layer. Could be worth playing with.

#takahe #fediverse #raspberrypi #homelab

@fritshoogland that is very cool, the fact that you are reusing codebase here. That alone tells me a lot!

I am very interested on this, yet I have no applicable use. Hope you don't mind if I ask you a bunch of questions.

Or... if you want to direct me to read something in particular, that's good too 👍

I basically want to know "what are we giving up" when using #Yugabyte instead of #PostgreSQL. (cons on single server and/or low count of servers)

@fritshoogland I wonder, how close is #Yugabyte to #PostgreSQL? Is the query planning as good? does it support the same level of SQL? How well it performs in single-cluster vs postgreSQL?

I would be interested on seeing benchmarks of complex queries with >10GiB databases to see how much performance would be lost compared to #PostgreSQL

If it's not much, Yugabyte might be interesting for DBs that you might to run in cloud, even for regular data sizes, just in case it becomes too big later on.

After having a look at #cockroachdb and #yugabyte database licenses, I find surprised that CockroachDB backtracked and it's now closed software.

But anyway, these two seem both oriented at selling it as a service, not really #foss. Or at least my impression.

There is market for a totally distributed cloud alike #PostgreSQL. And it is doable because at least there are two products out there. #citus seems to be lacking multimaster, and not sure if integrates with #BDR