自己要写个小软件,主要是数据查询的功能。但我不想用sqlserver,oracle之类的。
请问有没有能打包在应用程序里的小数据库(支持sql查询),这样我只要发给别人一个应用程序就马上可以使用了。
我听说过 cloudspace和consus等开源的portable database,但以前没有这方面的经验,希望有朋友可以提供帮助。
请问有没有能打包在应用程序里的小数据库(支持sql查询),这样我只要发给别人一个应用程序就马上可以使用了。
我听说过 cloudspace和consus等开源的portable database,但以前没有这方面的经验,希望有朋友可以提供帮助。
-------------------------------------------HSQLDB documentationSpecificationsThese are the general features: * Java, nothing else
* A full RDBMS (Relational Database Management System)
* Standard SQL (Structured Query Language) syntax
* Correlated subqueries, inner and outer joins are possible
* ORDER BY and GROUP BY are supported
* COUNT, SUM, MIN, MAX, AVG and other functions
* Transaction support
* Supports Referential Integrity (foreign keys)
* Java Stored Prodecures and Functions can be called
* Database Security functions
* 95% JDBC interface support
* All JDBC data types supported, also 'Object'
* Autoincrement column support
* No (real) size limitation for cached tables
* Indexes can be created for one or many fields
* Metadata support
* Readonly connection and database support Current restrictions are: * GROUP BY is limited
* HAVING, ANY, ALL are currently not implemented
* No triggers and views
* The size of Binary data is limited to about 32 KB (because UTF is used)
* No server side cursors (here is a workaround for selecting big results)
* Empty space in the database file is not always re-used (here are the details and a workaround)