Stored this way SQLite offers some date/time functions to add days, change to the start of the month and things like that. Together with the publishing time it would look like this: " T07:58". The string to represent the 28th of March 2013 (the day of publishing this post) would be " ". The best thing to do is to store dates as Strings in the ISO 8601 format. The biggest problem here is the missing datetime type. double precision)Īny String and also single characters (UTF-8, UTF-16BE or UTF-16LE) SQLite datatypes TypeĪny number which is no floating point numberįloating-point numbers (8-Byte IEEE 754 - i.e. If you use other types (like varchar) in your CREATE TABLE statement SQLite maps them as closely as possible to any of these types. The following table shows all types supported by SQLite. Newer versions add a journal file which is used during transactions. This file contains the main data, as well as indices, triggers and any meta data needed by SQLite itself. SQLite uses one file to store all the contents of your database. All data is stored in one single database file I will cover how to create a database in the next part of this tutorial series. You simply create the database files when you need it. No port configuration, no adding of users, no managing of access levels, no tablespace setup and what not. You do not need to configure the database in any way. You use SQLite more like a library which helps you to access the database files. There is no SQLite process running at all. I will delve into each of these points a bit deeper - and add another one that's only relevant if you want to support older Android versions. SQLite uses cross-platform database files.
0 Comments
Leave a Reply. |