Modify a Column’s Type in sqlite3
SQLite doesn’t support removing or modifying columns, apparently. But do remember that column data types aren’t rigid in SQLite, either. See also: SQLite Modify Column
sqlite
Is there a boolean literal in SQLite?
From section 1.1 Boolean Datatype of the docs: SQLite does not have a separate Boolean storage class. Instead, Boolean values are stored as integers 0 (false) and 1 (true). So it looks like you are stuck with 0 and 1.
What is the difference between related SQLite data-types like INT, INTEGER, SMALLINT and TINYINT?
SQLite, technically, has no data types, there are storage classes in a manifest typing system, and yeah, it’s confusing if you’re used to traditional RDBMSes. Everything, internally, is stored as text. Data types are coerced/converted into various storage locations based on affinities (ala data types assigned to columns). The best thing that I’d recommend you … Read more
Are there any reserved words in SQLite?
Yes, see http://www.sqlite.org/lang_keywords.html for the list. You can bracket them, but it isn’t standard SQL. Also, see http://www.sqlite.org/lang_keywords.html
Add ON DELETE CASCADE behavior to an sqlite3 table after it has been created
SQLite’s ALTER TABLE command cannot do what you want. However, it is possible to bypass the SQL interpreter and change the internal table definition directly. SQLite stores table definitions as a textual copy of the CREATE TABLE command in its sqlite_master table; check out the result of this query: SELECT sql FROM sqlite_master WHERE type=”table” … Read more
change sqlite file size after “DELETE FROM table”
The command you are looking for is vacuum. There is also a pragma to turn auto-vacuuming on. From the documentation: When an object (table, index, trigger, or view) is dropped from the database, it leaves behind empty space. This empty space will be reused the next time new information is added to the database. But … Read more
SQLite table constraint – unique on multiple columns
Put the UNIQUE declaration within the column definition section; working example: CREATE TABLE a ( i INT, j INT, UNIQUE(i, j) ON CONFLICT REPLACE );
How do DATETIME values work in SQLite?
SQlite does not have a specific datetime type. You can use TEXT, REAL or INTEGER types, whichever suits your needs. Straight from the DOCS SQLite does not have a storage class set aside for storing dates and/or times. Instead, the built-in Date And Time Functions of SQLite are capable of storing dates and times as … Read more
How Scalable is SQLite? [closed]
Yesterday I released a small site* to track your rep that used a shared SQLite database for all visitors. Unfortunately, even with the modest load that it put on my host it ran quite slowly. This is because the entire database was locked every time someone viewed the page because it contained updates/inserts. I soon … Read more
Creating stored procedure and SQLite?
SQLite has had to sacrifice other characteristics that some people find useful, such as high concurrency, fine-grained access control, a rich set of built-in functions, stored procedures, esoteric SQL language features, XML and/or Java extensions, tera- or peta-byte scalability, and so forth Source : Appropriate Uses For SQLite