Tag: SQLite

Many free open-source data processing engines can be embedded in Java application, among which, SQLite has been used for a long time, and used by many users, and esProc SPL, as a rising star, is also strong in functionality. This article will compare them in many aspects. Basic features Language style SQLite uses the traditional SQL code (the two are equivalent in this article). SQL is popular in this industry, so there is no need to give a more introduction to it. SPL is a modern data computing language, whose style belongs to the simplified object-oriented language. SPL has the

Though a lot of embedded data engines for Java are available, the competent and effective ones are rare. Redis has poor computing ability and can only handle simple query scenarios. Spark has complex and heavy framework and is inconvenient to deploy and maintain. Embedded databases like H2\HSQLDB\Derby have lightweight frameworks but they lack sufficient computing abilities – they even do not support the basic window functions. SQLite achieves the best balance between a good framework and satisfactory computing ability. It is now a widely-used Java embedded data engine. SQLite suits regular basic computing scenarios SQLite has lightweight framework. The library