Comment by ๐Ÿ Addison

=> Re: "Exporting Bubble data in a "raw" format?" | In: s/Bubble

JSON (and to a lesser extent CSV) is pretty much ubiquitous for this kind of thing in my opinion, and is use-case-agnostic (which SQL is not)

I'm in favor of JSON for the sake of its simplicity and universality.

=> ๐Ÿ Addison

2023-05-28 ยท 2 years ago

Poll Results

  1. SQLite3 database file

โ–ˆโ–ˆโ–ˆโ–ˆโ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ– 15%

  1. SQL database dump (text file with SQL)

โ–ˆโ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ– 5%

  1. JSON file with structured data

โ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–โ–โ–โ–โ–โ– 75%

  1. YAML file

โ–ˆโ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ– 5%

  1. TOML file

โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ–โ– 0%

20 votes were cast.

2 Later Comments โ†“

=> ๐Ÿฆ€ jeang3nie ยท 2023-05-28 at 13:30:

@Addison I agree, and it's the same reasoning I had for voting json. Either json or csv are both easy to parse in any language so making sense of the raw data outside the context of a database is possible.

=> ๐Ÿ•น๏ธ skyjake [OP/mod...] ยท 2023-05-29 at 20:37:

I think the results are starting to look pretty clear. I will do a JSON export and consider an SQLite file as a secondary option.

Original Post

=> ๐ŸŒ’ s/Bubble

Exporting Bubble data in a "raw" format? โ€” In addition to the human-readable Gempub archives, I've been considering various options for exporting your data out of Bubble in case someone wants to get their data out for other purposes. For example, one might want to use their posts as a basis for a personal capsule, or run some scripts to post-process them somehow. What would be the best "raw" machine-readable export format? Any good alternatives not listed?

=> ๐Ÿ’ฌ skyjake [mod...] ยท 10 comments ยท 2023-05-25 ยท 2 years ago ยท ๐Ÿ—ณ๏ธ

Proxy Information
Original URL
gemini://bbs.geminispace.org/u/Addison/1153
Status Code
Success (20)
Meta
text/gemini; charset=utf-8
Capsule Response Time
70.835365 milliseconds
Gemini-to-HTML Time
0.869739 milliseconds

This content has been proxied by September (ba2dc).