studio icon indicating copy to clipboard operation
studio copied to clipboard

Feature Request: Access and edit the database

Open mikeott opened this issue 1 year ago • 4 comments

What

It would be great if we could access the database in a browser, similar to PHPmyAdmin and alike.

Why

From a developers perspective, not having convenient access to the database to make quick edits or confirmations is a deal-breaker.

How

No response

mikeott avatar Aug 04 '24 02:08 mikeott

WordPress Studio is better than alternatives like XAMPP, WampServer and Laragon. People and myself face many issues and annoying things using those apps. Having the DB view/add/edit/delete feature will eliminate the need for those other tools for so many people.

babakfp avatar Feb 26 '25 18:02 babakfp

Related: https://github.com/Automattic/studio/issues/1033

ramonjd avatar Mar 21 '25 07:03 ramonjd

It just crossed my mind, could we just use whatever drizzle uses, Drizzle Studio?

I thought it's free and open-source, but it seems like it's a paid product https://github.com/drizzle-team/drizzle-studio-npm?tab=readme-ov-file#pricing.

babakfp avatar Mar 25 '25 01:03 babakfp

I think Drizzle ORM is free. It would be interesting to test its SQLite integration:

https://orm.drizzle.team/docs/get-started-sqlite

I was testing with better-sqlite3 but I'd also like to give libSQL a crack.

ramonjd avatar Mar 25 '25 02:03 ramonjd