Valentina SQLite brings together the most popular, public domain, open source database software with the networked server advantages of Valentina technologies.
What is SQLite?
Here is the industry standard definition of SQLite:
SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The source code for SQLite is in the public domain.
The SQLite Problem
Many developers - from large corporations like Apple, Inc to small ISVs use SQLite for local data storage in consumer applications. It has all the standard features of a local database. It is well supported. And as its public domain, it carries even fewer intellectual property restrictions than most FOSS solutions.
But there is a major omission that prevents real scalability - SQLite is serverless. And it was intended that way.
Some developers jury rig a solution out of a local SQLite database communicating with another type of server, such as PostgreSQL. Or for multi-user access, they cobble together a method for opening local databases across a network - putting their customer data at unnecessary risk. These needs are:
- The same type of database on both sides to scale up my applications to client-server
- A server infrastructure with industry standards in access control, security and administration
- A solution that doesn't introduce a lot of new bugs and issues into my solution
The Valentina SQLite Solution
You do not need to invent your own client-server protocol or use limited, poorly supported single platform third party solutions.
Valentina Server is the only solution for enterprise ready multi-user access for SQLite databases. Valentina Server incorporates a complete SQLite Server with a mature server infrastructure.