Better and better, thanks John. That's great, I'd seen mention of TOAST but wasn't sure how it fit in. Now after 1 hour total, I'm feeling like a PostgreSQL smartie ;-)
Since we're on this (not 4D) subject, I'll just mention a key detail about jsonb queries in PostgreSQL: They cannot take advantage of the query optimizers frequency tables. I don' think that 4D has frequency tables (or at least not much, cluster B-Trees might do much the same.) The idea is to maintain a list of unique values in a table and their occurrence. This lets the query planner optimize individual queries based on the values in your query statement and the values in your database. So, the database engine maintains table statistics per table, to improve performance. Sweet. Rob has a PostgreSQL plug-in for 4D: http://www.pluggers.nl/product/postgresql-plugin/ I checked the manual and it made no mention of json or jsonb field types. I wrote Rob and he says that passing the data as text works just fine with PostgreSQL. PostgreSQL has long had an extensible type system and it's able to coerce text values into more specific types on the server. (Assuming I understood Rob correctly and am not mis-quotting.) My biggest problem with PostgreSQL is the relative lack of nice front-end tools. My beloved SequelPro for MySQL has long hinted at a PostgreSQL version, but it doesn't seem to be there yet. For MySQL though, it's great (and free): http://www.sequelpro.com/ Navicat can do more (stored procedures, copy data across structures, better trigger support, etc.) but, dang, that "Look Ma! I wrote it in Java!" UI is just so ugly. I'll pay for it, I'll use it, I'll be grateful...but I won't be loving it. Any recommendations for good PostgreSQL tools? ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
