4 ms·

I have experience with this. Give a powerful SQL editor to a suit and find your data integrity borked beyond repair.

• striking 7y ago
  Read only?
• tracker1 7y ago
  For this, could probably dump/replicate to SQLite for archive/backup/point in time... Or one-way replicate for reports.
  • eloff 7y ago
    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.
  • amylene 7y ago
    This is how PowerBI, from Microsoft, works. It copies the data into local RAM (or on a cloud machine that also runs the dataviz)
• deleted 7y ago
  [deleted]