Step 2: Click on Add File. Mac Sqlite Tool. Step 3: View Sqlite File. Step 4: Export Sqlite File. Watch Live Video Here. Sqlite Viewer Mac Specifications. Sqlite Database Browser iPhone software capable to install with Windows OS only so copy all files from Mac, iOS, iPhone to Windows OS desktop after that you can browse overall. DB Browser for SQLite - PortableApp Note - If for any reason the standard Windows release does not work (e.g. Gives an error), try a nightly build ( below ). Nightly builds often fix bugs reported after the last release. Database Browser is a free tool that will open a DB file on your system or Mac. Download the version for your system. Install the application. Open DB Browser from the start menu. Click Open Database. It’s at the top of the app. Navigate to the database file you want to open. Select the file and click Open. Feb 01, 2021 DB Browser for SQLite (was SQLite Database Browser) is a high quality, visual, open-source tool to create, design, and edit database files compatible with SQLite. It is for users and developers wanting to create databases, and search and edit data. It uses a familiar spreadsheet-like interface, and you don't need to learn complicated SQL commands.
Database Converters for Windows
Convert your Excel, Access, DBF, CSV, XML files
to different formats with ease.
All converters support GUI and command line interface.
Database Converters for OS X
Convert your Excel, DBF, CSV files
to different formats with ease.
All converters support GUI and command line interface.
DBF Tools
Set of products:
Powerful DBF Editor,
DBF Recovery Tool
DBF Script
CSV to DBF Converter
CSV to DBF Converter allows you to convert your csv (comma-separated value) files to dbf format. you can customize the output file, say select the output codepage etc.
CSV to DBF Converter for Mac
CSV to DBF Converter for Mac allows you to convert your csv (comma-separated value) files to dbf format. you can customize the output file, select the output codepage etc.
CSV to XLS (Excel) Converter
CSV to XLS (Excel) Converter allows you to convert your CSV files to Excel format (xls, xlsx). The converter supports both 95-2003 MS Office format and 2007-2010 format too.
CSV to XLS (Excel) Converter for Mac
CSV to XLS (Excel) Converter for Mac allows you to convert your CSV files to Excel format (xls, xlsx). The converter supports both 95-2003 MS Office format and 2007-2010 format too.
CSV to SQLite Converter for Mac
CSV to SQLite Converter for Mac allows you to convert your csv (comma-separated value) files to SQLite database (.DB).
XLS (Excel) to DBF Converter
XLS (Excel) to DBF allows you to convert your XLS files to DBF format. It is very simple to use. It supports both Excel formats, 98-2003 and 2007. The program supports command line interface.
XLS to DBF Converter for Mac
XLS to DBF Converter for Mac allows you to convert your Excel files to DBF format. The program supports both XLS and XLSX formats.
XLS (Excel) to CSV Converter
XLS (Excel) to CSV allows you to convert your XLS files to CSV format. It is very simple to use. It supports both Excel formats, 98-2003 and 2007. The program supports command line interface.
XLS to CSV Converter for Mac
XLS to CSV Converter for Mac allows you to convert your Excel files to csv (comma-separated value) format. Generally, you can use any delimiter, such as TAB, semicolon etc.
XLS to JSON Converter
XLS to JSON allows you to convert your Excel files to JSON format. You can choose format of JSON: Compact, Pretty Printed or combination of both.
Converter for Excel & MySQL
Converter for Excel & MySQL is software for migrating from MS Excel to MySQL / MariaDB / Percona.
Converter for Excel & MS SQL
Converter for Excel and SQL Server is a software to convert Excel spreadsheets into SQL Server.
MDB (Access) to DBF Converter
MDB (Access) to DBF allows you to convert your MDB files to DBF format. It is very simple to use. The program supports command line interface.
MDB (Access) to XLS (Excel) Converter
MDB (Access) to XLS (Excel) Converter allows you to convert your Access files (mdb, accdb) to Excel format (xls, xlsx). The converter supports both 95-2003 MS Office format and 2007-2010 format too.
MDB (Access) to CSV Converter
MDB (Access) to CSV allows you to convert your MDB files to CSV format. It is very simple to use. It supports both Access formats, 98-2003 and 2007. The program supports command line interface.
Converter for Access and FoxPro
Converter and DBSync for FoxPro and Access database migration tools are useful for conversion and sync between FoxPro and Access databases.
DBF to CSV Converter
DBF to CSV allows you to convert your dbf files to csv (comma-separated value) format. Generally, you can use any delimiter, such as TAB, semicolon etc.
DBF to CSV Converter for Mac
DBF to CSV Converter for Mac allows you to convert your dbf files to csv (comma-separated value) format. Generally, you can use any delimiter, such as TAB, semicolon etc.
DBF to JSON Converter
DBF to JSON allows you to convert your dbf files to JSON format. You can choose format of JSON: Compact, Pretty Printed or combination of both.
DBF to XLS (Excel) Converter
DBF to XLS allows you to convert your dbf files to XLS (Excel) format. It allows you to transfer your dbf files to XLS quickly and easily.
DBF to XLS (Excel) Converter for Mac
DBF to XLS Converter for Mac allows you to convert your dbf files to XLS (Excel) format. It allows you to transfer your dbf files to XLS quickly and easily.
DBF to MDB (Access) Converter
DBF to MDB (Access) allows you to convert your dbf files to MDB (Microsoft Access) format. MDB format is the most frequently used format and DBF2MDB is designed for fast and reliable conversion.
DBF to SQL Converter
DBF to SQL allows you to convert your dbf files to SQL script. You can apply this script on any SQL server, so you can easily transfer your data to a new system.
DBF to SQL Converter for Mac
DBF to SQL Converter for Mac allows you to convert your dbf files to SQL script. You can apply this script on any SQL server, so you can easily transfer your data to a new system.
DBF to SQLite Converter for Mac
DBF to SQLite Converter allows you to convert your dbf files to SQLite database (.DB). This program could be very helpful for everyone who need to transfer your data from dbf to iOS, OSX, WEB, etc.
DBF to XML Converter
DBF to XML allows you to convert your dbf files to XML (Extensible Markup Language) format. XML is a universal data format.
DBF to XML Converter for Mac
DBF to XML Converter for Mac allows you to convert your dbf files to XML (Extensible Markup Language) format. XML is a universal data format.
DBF to DBF Converter
DBF to DBF allows you to convert your dbf files from one format to another. The program supports dBase III, dBase IV, FoxPro, VFP and dBase Level 7 formats.
DBF to DBF Converter for Mac
DBF to DBF Converter for Mac allows you to convert your dbf files from one format to another. The program supports dBase III, dBase IV, FoxPro, VFP and dBase Level 7 formats.
DBF to HTML Converter
DBF to HTML allows you to convert your dbf files to HTML pages. It allows you to create a single page or many pages with a navigation bar.
DBF to PDB Converter
DBF to PDB allows you to convert your dbf files to PDB (Palm DataBase) format. PDB is standard PalmOS files (Palm Data Base).
Converter for FoxPro and MySQL
Converter for FoxPro and MySQL migration and synchronization wizards guide you through easy steps to convert and replicate your data fast with no hassle.
Converter for FoxPro and MS SQL
DBConvert/DBSync for FoxPro and SQL Server is intended for database conversion and synchronization between Visual FoxPro databases (.dbc) and Visual FoxPro free tables (.
Sqlite Online Reader
CDBF - DBF Viewer and Editor
GUI version of CDBF for Windows is a powerful dbf viewer and editor that lets individuals and business users access dbf files directly without programming via the familiar Windows interface.
CDBF - DBF Viewer and Editor for OS X
CDBF is a powerful DBF Viewer and Editor. It allows you to review files created in FoxPro, Clipper, XBase and so on. CDBF supports dBase III, dBase IV, FoxPro, Visual FoxPro, SMT formats.
CDBF - DBF Viewer and Editor for iOS
It is a powerful dbf viewer that lets individuals and business users access dbf files. You can view and edit dbf files, view a structure of files;
CDBFinfo Shell Extension
The CDBFinfo Shell extension allows you to view brief information about a DBF file without opening it.
CDBF Shell Extension
The CDBF Shell extension allows you to view content or structure of DBF files in the 'Properties' window without opening them.
CDBFview - DBF plugin for Total Commander
CDBFview is a plugin for Total Commander. It allows you to view DBF files in Lister's window (Also in Quick View Panel).
CDBF - DBF Viewer and Editor, console version
Console version of CDBF for Windows is a small yet powerful application designed for viewing and editing database files in the DBF format.
DBF Viewer and Editor for Linux
CDBF for Linux is a console DBF file viewer and editor with rich functionality.
CDBF - DBF Viewer and Editor, DOS version
CDBF for DOS is a powerful database viewer and editor that lets individuals and business users access databases directly without programming via the text interface.
DBF repair tool
DBF Reanimator is a powerful tool that allows you to repair dbf files. The process of recovery dbf files is absolutely easy.
Just open a dbf file and then save it under another name.
CDBFlite - multiplaform console DBF Viewer and Editor
The CDBFlite program allows users to work with .DBF files format from the command line. You can carry out various actions which don't require you to be in batch mode.
DBF Script
DBF Script is a powerful tool which allows you to create small programs (scripts) to manage dbf files. It is useful for the programmers who want to make something special with DBF files.
CDBFAPI, powerful library for working with dbf files
CDBFAPI - it's a powerful library for working with files in DBF format. It does not require any database drivers, like ADO/BDE/ODBC. You can use CDBFAPI under Windows, iOS, OSX.
Excel Library
Excel library for developers can read and write Excel files. It does not require Microsoft Excel and combines an easy to use and powerful features.
The Mono.Data.SqliteClient assembly contains an ADO.NET data provider for the SQLite embeddable database engine (both version 2 and version 3).
SQLite has a notable oddity: table cell data does not retain what kind of data it was. Everything is stored as either a long, double, string, or blob. And in SQLite version 2, everything is stored as a string. So you need to be careful about avoiding casting values returned by SQLite without checking the type of the value returned. See below for notes on storing DateTimes.
Table of contents |
New style assembly shipped with Mono 1.2.4
Starting with the 1.2.4 release, Mono ships a second SQLite assembly - Mono.Data.Sqlite. The new assembly provides support only for SQLite version 3and is not 100% binary and API compatible with the older assembly. The new assembly is based on code by Robert Simpson from http://sqlite.phxsoftware.com/ and provides full ADO.NET 2.0 API interface. Code from the old binary is contained in the new one but is available only in the 1.1 profile. The 2.0 profile can no longer access the old code when referencing the new assembly. We have chosen this way as means to provide a migration path for developers using SQLite in their .NET applications - both assemblies will be shipped with several future releases of Mono, and at some (yet undetermined) point the old one will be removed from the distribution. All the developers are encouraged to start transitioning their code to the new assembly - for both 1.1 and 2.0 profiles.
One disadvantage of the new assembly is its binary incompatibility in the data format. That is, if your application uses SQLite database v2 format you will not be able to access your data with the new assembly. To solve this problem you must dump your data using sqlite v2 utilities and then restore it using sqlite v3 utilities.
Prerequisites
If you do not have SQLite, download it. There are binaries for Windows and Linux. You can put the .dll or .so along side your application binaries, or in a system-wide library path.
Connection String Format
The format of the connection string is:
The latter case for the 2.0 profile references the App_Data directory (or any other directory that’s configured to contain data files for an ASP.NET 2.0 application)
As an example:
That will use the database SqliteTest.db in the current directory. It will be created if it does not exist.
Or you prefer to use SQLite as an in memory database
The version=3
is supported, but not necessary with the new assembly.
With the old assembly, the ADO.NET adapter will use SQLite version 2 by default, but if version 2 is not found and version 3 is available, it will fallback to version 3. You can force the adapter to use version 3 by adding “version=3” to the connection string:
The new assembly, as described above, uses only database format version 3.
- Connection String Parameters:
For the 1.1 profile and the old assembly
Parameter Definition | Description | Example |
---|---|---|
URI | a file Universal Resource Identifier | URI=file:SqliteTest.db |
version | version of SQL Lite to use: version 2 or 3 | version=3 |
busy_timeout | a timeout, in milliseconds, to wait when the database is locked before throwing a SqliteBusyException (since Mono 1.1.14) | busy_timeout=3000 |
The busy_timeout parameter is implemented as a call to sqlite(3)_busy_timeout. The default value is 0, which means to throw a SqliteBusyException immediately if the database is locked.
For the 2.0 profile in the new assembly
Parameter Definition | Description | Example |
---|---|---|
Data Source | a file Universal Resource Identifier | Data Source=file:SqliteTest.db |
version | version of SQL Lite to use: version 3 | version=3 |
Storing DateTimes
The way DateTimes are stored and retrieved from Sqlite databases depends on a lot, unfortunately, because Sqlite doesn’t have a way of storing datetimes natively. Further, there are two versions of Sqlite (2 and 3) which are treated differently when it comes to DateTimes. The recommended way of using DateTimes with Sqlite is to encode/decode them yourself to/from some particular integer string format that you decide, and not putting them into a DATE or DATETIME column.
Sqlite2 only has strings internally. No matter what the column was declared as, DateTimes are just going to be converted into strings. If you use parameters, for instance, DateTimes will be converted in a culture-sensitive format. When reading back the data, there’s no way to know that it was originally a DateTime and not a string, so Mono.Data.SqliteClient returns the string. Using Sqlite2, you really can’t use DateTimes without encoding them yourself.
If you explicitly are targetting Sqlite3, or using the new assembly (in which case you should be providing the version parameter in the connection string, unless you are using the new assembly), you can rely on the particular behavior used when connecting to a Sqlite3 database. Sqlite3 has string, integer (64bit), real, and blob internal storage types. When putting a DateTime into the database using parameters, Mono.Data.SqliteClient will encode the DateTime as an integer using ToFileTime(). But this doesn’t help when reading the data back to determine that a value was originally a DateTime. Sqlite3 also exposes the names of the types of the columns as the table was created with. If a column is declared as a DATE or DATETIME, SqliteDataReader will try to turn the value back into a DateTime. If it finds an integer value, it uses DateTime.FromFileTime, which is the reverse of how it encodes DateTimes if you insert a DateTime via parameters. If it finds a string value, it uses DateTime.Parse, but note that Parse is a very slow operation. So with Sqlite3, DateTimes should be put into DATE or DATETIME columns in the database either through parameters or by turning it into a long with ToFileTime yourself, and then they will be read back as DateTimes.
Character Encodings
The Sqlite client treats character encodings differently for version 2 and version 3 because of the way Sqlite2 and 3 treat strings.
In Sqlite3, the Sqlite client communicates with Sqlite in Unicode. Therefore, you should be able to read and write any characters from the database, but note that if you write Unicode characters to a database, you may not be able to read them back in other applications if the application does not communicate with Sqlite using Unicode.
In Sqlite2, the client by default communicates with Sqlite using the UTF-8 encoding, which means you can read and write any character. But you must beware of two things. The first is that since non-ASCII characters are encoded as multi-byte characters in UTF-8, and Sqlite2 doesn’t recognize multibyte characters (unless it was compiled specifically with UTF-8 support), LIKE, GLOB, LENGTH, and SUBSTR will behave oddly. The second caveat is that other applications using the database must be using UTF-8 as well.
When using Sqlite2, you can force Mono.Data.SqliteClient to use a different encoding instead of UTF-8 by adding “;encoding=ASCII” for instance to the connection string. It must be an encoding that ends with a single null terminator, however.
C# Example (1.1 profile of the new assembly and the old assembly)
Free Sqlite Reader Mac Os
To build the example:
- Save the example to a file, such as, TestExample.cs
- Build using Mono C# compiler:
Free Sqlite Viewer
To run the example: