frectonz's comments

On: Show HN: Embed an SQLite database in your PostgreSQL table

[frectonz]

yes you can

CREATE TABLE crime_against_humanity ( databases SQLITE[] );

[michelpp → frectonz]

With the expanded datum api you can also work with subscriptable array types to only expand elements lazily as needed. It might already works if you try it, but support for it might be hardwired only to nested stock arrays, something to look into.

On: Show HN: Embed an SQLite database in your PostgreSQL table

[frectonz]

oh nice, i didn't know this existed, thanks

[Tostino → frectonz]

The string between the dollar signs can only be closed by another set of dollar quotes with the same string between them. So it allows you to do quotes within quotes within quotes if necessary.

On: Show HN: Embed an SQLite database in your PostgreSQL table

[frectonz]

That's the sensible option but not the fun one.

On: Show HN: Embed an SQLite database in your PostgreSQL table

[frectonz]

Thanks i will look into this more, /tmp stuff is most definitely a hack.

[michelpp → frectonz]

Here's an example of a simple expanded object to start from:

https://github.com/michelp/pgexpanded

On: Show HN: Embed an SQLite database in your PostgreSQL table

[frectonz]

My next project

On: Show HN: If YouTube had actual channels

[frectonz]

Somebody finally made the Interdimensional Cable from Rick and Morty.

On: Show HN: SQLite Database Explorer

[frectonz]

It is a CLI tool that starts a local web server. After you install it, you can run `sqlite-studio <your_db>` and then you will see a log that says "listening on http://127.0.0.1:3030". When you open that page you will see the dashboard.

On: Show HN: SQLite Database Explorer

[frectonz]

We have some screenshots on the github releases page (https://github.com/frectonz/sqlite-studio/releases). Would be better to take a look at the hosted preview (https://sqlite-studio.frectonz.io/) though.

It is a CLI tool, that creates a local server. I will make the readme better soon.

[SamBam → frectonz]

Second link seems hugged.

On: Show HN: SQLite Database Explorer

[frectonz]

yeah sorry, i didn't know there was another tool with the same name, i will change it soon.

On: Show HN: SQLite Database Explorer

[frectonz]

Yeah that's true. I didn't think people would be this interested. Will add more info.

[cottsak → frectonz]

i was looking for the screenshot too.

[frectonz → cottsak]

You can checkout the hosted preview (https://sqlite-studio.frectonz.io/). We also have some screenshots on the github releases page (https://github.com/frectonz/sqlite-studio/releases).

[giis → frectonz]

At-least for now, you need to move these into readme.md These animated gif gives better idea about this tool! nice work!

[frectonz → giis]

Thanks, i have moved them now.