SQLite as an Application File Format (2014)

Re:SQLite as an Application File Format (2014) by ineedasername on Tuesday December 25, 2018 @08:48AM (#18757375)

That is a truly fantastic idea. Especially if Excel added file format support for it directly to open it within excel with a double click, one table per sheet within the workbook. I know, not the ideal way to use SQLite, but that would ensure easy adoption by the average person that doesn't have SQL or relational database knowledge. (And would allow them to get a bit of that relational knowledge via power query)

Some might think Access would be the more obvious choice, but for the average user Access is not an accessible tool (we don't even install it as part of the Office suite where I work) and they're much more comfortable in Excel.

[ Parent | on HN ]

Re:SQLite as an Application File Format (2014) by m_sahaf on Tuesday December 25, 2018 @12:14PM (#18758115)

I've probably said this around here before, but I wish people trade SQLite files instead of Excel workbooks. Excel (and the like) can operate on top of SQLite. This way we have data portability, data integrity, and ease of data access.

[ Parent | on HN ]

Re:SQLite as an Application File Format (2014) by your-nanny on Tuesday December 25, 2018 @10:59AM (#18757839)

Read only, or Excel would have to enforce constraints. But, yes, would be nice

[ Parent | on HN ]