SQLite has features often found in high-end databases such as JSON support and full-text indexing. SQLite has been ported to various platforms: Windows, macOS, Linux, iOS, Android, and more.” According to InfoWorld, “One of SQLite’s greatest advantages is that it can run nearly anywhere. It is stable, fully backward compatible, and supports all major programming languages. The SQLite started in 2000 and has an international community of developers committed to supporting the project until 2050. It is the most widely deployed SQL database in the world. SQLite is a self-contained, transactional SQL database engine is software that allows access to other databases. Understanding how to import and export data in SQLite is vital for developers to learn how to migrate and transfer data in and out of the database.

Unlike full-strength relational databases like MySQL or PostgreSQL, SQLite works well for testing applications and providing essential app functions. Save the query using a descriptive name such as 'Inventory Report.' Double-click the query to open it and view the number of units on hand for each product in the database.When you need a small, lightweight database to use on a local computer or used in all mobile telephones, SQLite is the developer’s choice. Product ID, Product Name and Quantity on hand all would be useful fields to include. Select the Inventory table as the input source and double-click the fields you want to show on your query. Choose 'Queries' and use the 'Wizard' option. The information automatically is transferred to the underlying table.Ĭlose the form and go to the main database window. This creates a form automatically, using the field names from your inventory control table.Įnter your existing inventory data in the data entry form. Select the table you just created as the basis for your form. Save the table and give it a descriptive name, such as 'Inventory.' Close the table and go to the main database window.Ĭlick the 'Forms' section and use the 'Wizard' option.

Create additional fields based on your needs. Create a field for product name, product description, product number, quantity and unit of measure. Type the field names for your inventory control database into the table grid.

Openoffice base export sqlite