Question: How to access it from a GUI?

[BrunoQuaresma]

Hi folks, I'm playing around with the project and I'm using local files to store the data. Is there any GUI that would support pqlite? I would like to use it to debug things. Thank you!

[samwillis]

We've not built one yet, but it's on the list!

best way to debug for now it to make the db global so you can access it from the terminal, then just do queries there.

[jlucaso1]

It's possible to use something like drizzle studio?

[jueinin]

but i want to use it on browser, is there a GUI tool to view database?

[jueinin]

in browser env, may be you can try this project, https://github.com/datawan-labs/pg

just import src/main.tsx and provideo a container DOM node.

ensure import it within the same domain & port, otherwise, it can't read the pg indexdb files

[Jonovono]

@jlucaso1 you can use drizzle studio https://github.com/drizzle-team/drizzle-orm/issues/2823

[f0rr0]

Hey, I built https://github.com/f0rr0/pg-browser-proxy which lets you use any tool - drizzle studio, prisma studio, pgadmin etc. to interact with browser based databases. Check it out!

[thruflo]

@f0rr0 super cool!