DB Maintenance commands

[vasudev-gm]

First thing I want to say is I love the product and doesn't have steep learning and install file is quite small w/o needing tons of deps like PGAdmin 6, Mysql Workbench. Those random data entries through faker.js is amazing for quick test.
But few features are missing such as DB maintenance options for MySQL, Postgres, SQLite such as Optimize, Vacuum, check integrity etc..
Also not sure if faker random data generation is limited to 1000 entries, whenever I tried exceeding it nothing happens, so I usually generate 500 entries. Not sure if I should file this as bug?
Thanks for making one of the great open source products.

[Fabio286]

Hi @vasudev-gm,

But few features are missing such as DB maintenance options for MySQL, Postgres, SQLite such as Optimize, Vacuum, check integrity etc..

I think it is an excellent idea that I will certainly consider for future implementations.

Also not sure if faker random data generation is limited to 1000 entries, whenever I tried exceeding it nothing happens, so I usually generate 500 entries. Not sure if I should file this as bug?

The quota of 1000 is a safety limit I set. In the future, however, I may remove this limit by using a secondary process to perform inserts, somewhat like what happens with the import tool.

Thank you for the feedback and appreciation!

[vasudev-gm]

Thank you and happy to hear you'll take it up in a future roadmap/releases.