4 ms·

SQLite also requires external dependency and special execution environment and are not as portable as CSV.

• srcreigh 5y ago
  SQLite is included in most operating systems by default. It's also on macOS and iOS. It also runs on all kinds of embedded devices in addition to personal computers and servers. https://en.wikipedia.org/wiki/SQLite#Operating_systems https://en.wikipedia.org/wiki/SQLite#Operating_systems
  • deleted 5y ago
    [deleted]
  • lmilcin 5y ago
    Just because most popular operating systems have libraries, doesn't yet mean it is portable. Can I click on it and open it in Excel? If not then it is not portable for me and for a lot of other people. The main reason I use CSV is to produce reports that I can either open myself or send to other people so that they can click on it and open themselves and immediately start hacking away. Excel is still corporate lingua franca and until this changes CSV is not going to retire. CSV means for me that I can send it to anybody and everybody will know how to use it. Try sending SQLite binary to people you work with, to your accountant, to your wife. Then share your experience.
    • wombatpm 5y ago
      Try using tabs. Still open in excel with less problems
      • lmilcin 5y ago
        I find files where the exact type of whitespace used is meaningful to be a sick joke. Not all editors make it easy for you to use a tab character. If only there was some other solution that would not require you to use a character that a lot of editors refuse to insert or even try to convert to spaces...