I have legal constraints about data and I have to host myself. and I have to use a full audited and trailed database and my org is using mysql. can I use astrodb with it?
#can I use a local mysql database with astrodb?
brave lion
steel jewelBOT
Hi @brave lion. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base. :wave:
Astro DB is a fully-managed SQL database designed exclusively for the Astro ecosystem. It uses a hosted libSQL database that you can connect to during local development and in production, managed through the Astro Studio platform. Astro DB also provides a fully local libSQL database when you start up your dev server. However, there is no explicit mention of support for MySQL databases in the provided knowledge sources.
Astro DB is designed to be built from scratch on startup, and the database itself (data.db) is not persistent. It's created new from scratch every time you start up the dev server. This might not align with your requirement for a fully audited and trailed database.
For more information on Astro DB, you can refer to the Astro DB guide (https://docs.astro.build/en/guides/astro-db/) and the Astro DB deep dive blog post (https://astro.build/blog/astro-db-deep-dive).