I'll have to read more about sqlite_fdw. Thanks for that Steve !
Each SQLite isn't that big (billions of records), more like 30K records or so. But there are lots and lots of these SQLite DBs which add up over time to perhaps billions of records.
This is for a big corp with an IT dept. Maybe I can get them to upgrade the DB itself.
Thank You too David !
On Tue, Dec 21, 2021 at 10:14 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Tuesday, December 21, 2021, David Gauthier <davegauthierpg@xxxxxxxxx> wrote:OK, you get the picture. I'm all ears :-) And thanks in advance for any suggestions !This is basically a variant of “should I store images in the database” but the content sizes involved are insanely high compared to most images. External storage, with a pointer in the DB, would seem like a much better choice.Either way, though, not applying a minor release in over two years is just wrong; you should get on top of that before building new functionality on top of said database.David J.
