Use Valentina Forms as a user friendly front end for SQLite.
What is SQLite?
SQLite is an incredibly popular single connection, local database because it provides a stable, flat-file database solution for application developers. SQLite is an in-process library that implements a self-contained, server-less, zero-configuration, transactional SQL database engine. The source code for SQLite is in the public domain.
Using SQLite with Valentina Forms
Local Valentina Projects and Valentina Server Projects can both supply Valentina Forms based front ends for SQLite.
Other Valentina technologies also support SQLite, including Valentina Reports. Valentina Server also incorporates a multi-user database management system Valentina SQLite Server, allowing developers to scale up their single connection, SQLite based applications to a full multi-user database platform.
Forms and Valentina SQLite Server
Valentina Server includes several servers, including Valentina Reports Server and Valentina SQLite Server. Server projects can also include Forms, allowing your users to open a form remotely on your network and use it to work with data stored on Valentina Server.
Following a most compatible strategy, SQLite is embedded right into the Valentina Server kernel, allowing direct, local communication as well as remote communication using the Paradigma vCLIENT platform. Even with the SQLite native implementation of WAL (Write Ahead Logging) for atomic commit and roll back, other activity can come to a stop.
Valentina SQLite Server does not break compatibility but instead delivers a fast, stable and reliable SQLite as a Server solution without requiring you to rewrite a lot of code. Valentina SQLite Server take advantages of high efficiency optimizations used in Valentina DB Server, including image compression and zip compressed data.