How to store array in one column in Sqlite3?

by

SQLite3 does not support arrays directly. See here the type it supports. Basically, it only does Ints, Floats and Text.

To accomplish what you need, you have to use a custom encoding, or use an FK, i.e. create another table, where each item in the array is stored as a row.

More Related Contents:

  1. Faster bulk inserts in sqlite3?
  2. How to use SQLite in a multi-threaded application?
  3. Can I use parameters for the table name in sqlite3?
  4. What is a good OO C++ wrapper for sqlite [closed]
  5. sqlite3_exec() Callback function clarification
  6. Error: C2228: left of ” must have class/struct/union
  7. Error: undefined reference to `sqlite3_open’
  8. In C++, what is a virtual base class?
  9. Why doesn’t left bit-shift, “
  10. Py_Initialize fails – unable to load the file system codec
  11. How to call erase with a reverse iterator
  12. explicit specialization of template class member function
  13. Why can’t clang with libc++ in c++0x mode link this boost::program_options example?
  14. Why do compilers allow string literals not to be const?
  15. Why are lambda expressions not allowed in an unevaluated operands but allowed in the unevaluated portions of constant expressions?
  16. rvalue to lvalue conversion Visual Studio
  17. How do you determine the size of an object in C++?
  18. Get a file name from a path
  19. Fastest implementation of sine, cosine and square root in C++ (doesn’t need to be much accurate)
  20. How to define a string literal in gcc command line?
  21. May std::vector make use of small buffer optimization?
  22. How to enable visual styles without a manifest
  23. Is a constexpr array necessarily odr-used when subscripted?
  24. Determine path to registry key from HKEY handle in C++
  25. Is there a way to use C++ preprocessor stringification on variadic macro arguments?
  26. Returning a void?
  27. Is casting std::pair const& to std::pair const& safe?
  28. How to use sort() in C++ with custom sort member function?
  29. C++ templates declare in .h, define in .hpp
  30. Is it possible to invoke a user-defined conversion function via list-initialization?

Leave a Comment