News for hackers. Stuff that matters.
Re:Falcon is a free, open-source SQL editor with inline data... by tracker1 on Wednesday April 15, 2020 @07:34PM (#22884423)
For this, could probably dump/replicate to SQLite for archive/backup/point in time... Or one-way replicate for reports.
Re:Falcon is a free, open-source SQL editor with inline data... by eloff on Wednesday April 15, 2020 @09:14PM (#22885106)
I've used this strategy with a read only replica. It also protects the database from long running and inefficient queries. Highly recommend doing this if you have the budget for it.
Re:Falcon is a free, open-source SQL editor with inline data... by amylene on Wednesday April 15, 2020 @09:41PM (#22885241)
This is how PowerBI, from Microsoft, works. It copies the data into local RAM (or on a cloud machine that also runs the dataviz)