💾 Archived View for bbs.geminispace.org › u › Addison › 1153 captured on 2023-12-28 at 18:09:32. Gemini links have been rewritten to link to archived content
⬅️ Previous capture (2023-11-14)
-=-=-=-=-=-=-
Re: "Exporting Bubble data in a "raw" format?"
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.
May 28 · 7 months ago
1. SQLite3 database file
████▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁ 15%
2. SQL database dump (text file with SQL)
█▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁ 5%
3. JSON file with structured data
██████████████████▁▁▁▁▁▁ 75%
4. YAML file
█▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁ 5%
5. TOML file
▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁ 0%
20 votes were cast.
🦀 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 · 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.
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?