Category: TalkingData
An alternative of SQLite for Java Programmer
Many small and micro applications also need some data processing & computing capability, but the framework becomes too heavy if we integrate a database in them. In view of this, the small and lightweight SQLite has become a good choice and been widely used. SQLite also has its inconveniences. It has weak and complicated support for external data files and other data sources; it does not provide stored procedures and needs the main program’s participation in implementing the procedure, leading to frequent data exchanges between it and the main program (because the procedure flow depends on data) and resulting in
Use SQL without Databases
We have some csv/xls files as the following shows: SQL is suitable for handling those data, but the language depends on databases to work. We need to install a database and import the data into it to process. This results in bloated application system. Yet such a small task is not worth the effort. Is there a technology that can treat these files as data tables and use SQL to directly query them? esProc SPL is just what you expect. esProc SPL is an open-source software, which is offered in https://github.com/SPLWare/esProc. It provides standard JDBC driver. By importing it in







