TL;DR Yes, GraphQL does support a sort of pseudo-join. You can see the books and authors example below running in my demo project. Example Consider a simple database design for storing info about books: create table Book ( id string, name string, pageCount string, authorId string ); create table Author ( id string, firstName string, … Read more
The clob data type is unsupported in Postgres. However, it can be easily defined as a synonym to the text type: create domain clob as text;
They are not only different, they are orthogonal. Inconsistency: A DB that reported employee Joe Shmoe’s department as Sales but that didn’t list Joe Shmoe among the employees in the Sales department would be inconsistent. It’s a logical property of the DB, independent of the actual data. Integrity: A DB that reported jOe SaleS to … Read more
this code is more general but maybe it can help you: import sqlite3 new_db = sqlite3.connect(‘:memory:’) # create a memory database old_db = sqlite3.connect(‘test.db’) query = “”.join(line for line in old_db.iterdump()) # Dump old database in the new one. new_db.executescript(query) EDIT : for getting your specify table you can just change in the for loop … Read more
I encountered same issue: every time you get it, you have to allocate more space and run DBeaver itself first with additional flags -vmargs -Xmx*m. Replace * with 2048 or 4096. It doesn’t look like DBeaver takes garbage out when closing the script, so I had to restart application many times to check right amount … Read more
Probably one of the best explanations of SSTables and LSM-Trees for mortals is given by Martin Kleppmann in his “Designing Data-Intensive Applications” book. These data structures are explained in chapter 3, “Storage and Retrieval”, pages 69 through 79. It’s a really great read, I would recommend the whole book! Impatient ones could find my synopsis … Read more
If the query planner makes bad decisions it’s mostly one of two things: 1. The statistics are inaccurate. Do you run ANALYZE enough? Also popular in its combined form VACUUM ANALYZE. If autovacuum is on (which is the default in modern-day Postgres), ANALYZE is run automatically. But consider: Are regular VACUUM ANALYZE still recommended under … Read more
Use SHOW VARIABLES SHOW VARIABLES WHERE VARIABLE_NAME = ‘event_scheduler’
We have figured out the the cause of this issue. It’s explained by buggy implementation of setQueryTimeout() in latest JDBC drivers 9.2-100x. It might not happen if you open / close connection manually, but very often happens with connection pooling in place and autocommit set to false. In this case, setQueryTimeout() should be called with … Read more
Yes. Ensures that you don’t have an orphan (entry with no parent), and depending on usage, if you define a cascading delete, when a parent is deleted, all its children will also be deleted. Disadvantage would be a slight performance hit just like any other foreign key.