SQLite BLOB Type Features SQLite is a typeless database (dynamic typing), BLOB is the recommended type for binary data storage No fixed size limit for BLOB columns (limited only by the maximum SQLite database file size: ~140TB) Binary-safe storage (no character encoding/decoding for image ... Read more
Tag Archives: Sqlite
SQLite BLOB
In SQLite, the BLOB (Binary Large Object) data type is used to store binary data such as images, audio files, or any other non – text data. Here’s a comprehensive guide on working with BLOB in SQLite: 1. Creating a Table with a BLOB Column You can create a table with a BLOB column to ... Read more
Batch import RTF files into SQLite BLOB without programming
Want to batch import RTF (Rich Text Format) documents into SQLite CLOB (TEXT, NTEXT) or BLOB column? Using DBBlobEditor, you can import bulk rtf files into SQLite CLOB (TEXT, NTEXT) or BLOB easily and fast, just a few mouse clicks. Download DBBlobEditor Batch import RTF documents to SQLite CLOB ... Read more
Some ETL (Extract-Transform-Load) tools for SQLite
Withdata Software provide some ETL (Extract-Transform-Load) tools for SQLite: FileToDB Load TXT, CSV, TSV, XML, JSON, Excel, SQL, RDF, INI data to SQLite DBToFile Export SQLite data to TXT, CSV, TSV, XML, JSON, Excel, SQL files DBCopier Copy data between SQLite and other rational ... Read more
How to select N random records from a SQLite table
If you want to select N random records from a SQLite table, you need to change the clause as follows: select * from tableName order by RANDOM() limit N For example, to select 5 random customers in the customers table, you use the following query: select * from customers order by RANDOM() limit ... Read more
How to get index column names of a table from SQLite
select sql from sqlite_master where tbl_name='my_table_name' and type='index' you can find the index name and column names in ‘sql’ field. See also: How to get index column names of a table from DB2 How to get index column names of a table from SQL Server How to get index column names ... Read more
How to get primary key of a table from SQLite
Run PRAGMA table_info('my_table_name') find the record that column ‘pk’ is 1, it’s the primary key. See also: How to get primary key of a table from PostgreSQL How to get primary key of a table from MySQL How to get primary key of a table from SQL Server How to get primary key ... Read more
How to generate a CREATE TABLE statement for a given table in SQLite
select sql from sqlite_master where type='table' and tbl_name='country' See also: How to generate a CREATE TABLE statement for a given table in SQL Server How to generate a CREATE TABLE statement for a given table in Oracle How to generate a CREATE TABLE statement for a given table in ... Read more
How to get column names from SQLite table
PRAGMA table_info(table_name); see also: How to get column names from Sql Server table How to get column names from DB2 table How to get column names from Oracle table How to get column names from Mysql table How to get column names from PostgreSQL table Some SQLite tools you can try: ... Read more
Withdata Software Released SqliteLobEditor Version 1.1
Withdata software has announced sqlitelobeditor 1.1, a tool that helps you edit SQLite lob (blob, clob (text, ntext)) data directly. Version 1.1 Add “Create sub folders by field name”. Add “turning off log” in command line. Fix bug “logon to SQLite form UI ... Read more