FAQ
Frequently Asked Questions
Index
Is this Database Engine Open Source?
YES!
It's free to use and distributed, and the source code is included. See also license.
Is Commerical Support Available?
No, currently commercial support is not available.
How to Create a New Database?
By default, a new database is automatically created if it does not yet exist when the embedded URL is used.
How to Connect to a Database?
The database driver is org.guinsoo.Driver
, and the database URL starts with jdbc:guinsoo:
. To connect to a database using JDBC, use the following code:
Where are the Database Files Stored?
When using database URLs like jdbc:guinsoo:~/tset
, the database is stored in the user directory.
What is the Size Limit of a Database?
See Guinsoo Limits and Limitations.
My Query is Slow!
Slow SELECT
(or DELETE
, UPDATE
, MERGE
) statement can have multiple reasons. Follow this checklist:
Run
ANALYZE
(see documentation for details)Run the query with
EXPLAIN
and check if indexes are usedIf required, create additional indexes and try again using
ANALYZE
andEXPLAIN
If it doesn't help please report the problem.
Float is Double?
For a table defined as CREATE TABLE TSET(X FLOAT)
the method ResultSet.getObject()
returns a java.lang.Double
, I expect it to return a java.lang.Float
. What's wrong?
This is not a bug. According to the JDBC specification, the JDBC data type FLOAT
is equivalent to DOUBLE
, and both are mapped to java.lang.Double
. See also Mapping SQL and Java Types - 8.3.10 FLOAT.
Use REAL
or FLOAT(24)
data type for java.lang.Float
values.
Last updated