guinsoo's Introduction

Guinsoo

A metadata store database for GuinsooLab stack.

For more information please visit here.

Features

Super-fast, open source, JDBC API
In-memory, non-blocking store, designed for low-latency applications
Embedded and server modes; disk-based or in-memory databases
Transaction support, multi-version concurrency
Fulltext search
Encrypted databases

More information, please refer to here.

Overview

Working from the top down, the layers look like this:

JDBC driver.
Connection/session management.
SQL Parser.
Command execution and planning.
Table/Index/Constraints.
Transactions layer.
B-tree/ART.
Filesystem abstraction.

Quickstart

Step 1: Add maven dependency (click here to find more versions ð)

<dependency>
    <groupId>io.github.ciusji</groupId>
    <artifactId>guinsoo</artifactId>
    <version>0.2.2</version>
</dependency>

Step 2: Connect and execute SQL

Class.forName("org.guinsoo.Driver");
Connection conn = DriverManager.getConnection("jdbc:guinsoo:mem:");
Statement stat = conn.createStatement();

stat.execute("YOUR SQL");

stat.close();
conn.close();

For more language, such as Python, Java, C++, Rust, Node or others, please click here.

Documentation

Guides

Reference

Support

Appendix

Issues

Issue tracker for bug reports and feature requests.

Others

guinsoo's People

Contributors

Stargazers

Watchers

guinsoo's Issues

offheap store panic!

Syntax error in SQL statement with psycopg2

envs: (MacOS m1 chip)
python3.9
psycopg2-binary==2.8.6

Guinsoo:
mode: postgresql

Error details:
2022-11-20 10:58:40,006:ERROR:flask_appbuilder.security.sqla.manager:Add Role: (psycopg2.errors.SyntaxErrorOrAccessRuleViolation) Syntax error in SQL statement "INSERT INTO ab_role (id, name) VALUES (nextval('ab_role_id_seq'), E'Admin') []RETURNING ab_role.id"; SQL statement:
INSERT INTO ab_role (id, name) VALUES (nextval('ab_role_id_seq'), E'Admin') RETURNING ab_role.id [42000-219]
DETAIL: org.guinsoo.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "INSERT INTO ab_role (id, name) VALUES (nextval('ab_role_id_seq'), E'Admin') []RETURNING ab_role.id"; SQL statement:
INSERT INTO ab_role (id, name) VALUES (nextval('ab_role_id_seq'), E'Admin') RETURNING ab_role.id [42000-219]

[SQL: INSERT INTO ab_role (id, name) VALUES (nextval('ab_role_id_seq'), %(name)s) RETURNING ab_role.id]
[parameters: {'name': 'Admin'}]
(Background on this error at: http://sqlalche.me/e/13/f405)

ciusji / guinsoo Goto Github PK