Skip to content

sqlite-server-0.3.28-release

Choose a tag to compare

View all tags
@forchid forchid released this 04 Dec 09:41
sqlited-0.3.28
5692f13

SQLite Server (sqlited)

A high performance SQLite server engine based on the client/server architecture and org.xerial sqlite-jdbc project.

  • Inherit all characteristics of SQLite that is small, fast, self-contained, high-reliability, full-featured, and ACID complete SQL database engine
  • Implement a subset(PgServer) of postgreSQL frontend/backend protocol for supporting pgjdbc , psql, or ODBC
  • Support md5(default), password and trust authentication methods in PgServer
  • High performance(1000+ read/write transactions per second, "select count(*)... where NON_INDEX_COLUMN condition" returns in 1s on 10000000+ rows table, insert 50,000 ~ 100,000+ rows per second in wal & normal mode)
  • Add a feature of user, privilege and database management for SQLite server engine
  • Use NIO infrastructure for supporting many connections by a few threads, SQLite server workers is default CPU cores
  • Added some SQL statements that include "create user", "alter user", "drop user", "show users", "grant", "revoke", "show grants", "create database", "show databases", "drop database", "show [full] processlist", "kill [connection|query] processor_id" for administrative purposes
  • Added some SQL functions such as "user()", "current_user()", "version()", "server_version()", "database()", "current_database()", "start_time()", "sysdate()", "clock_timestamp()", "sleep(N)"
  • Added "begin read only | read write", "set {transaction | session characteristics as transaction} read only | read write" to support read only or read write transaction in a connection
  • Support "insert into ...{values()... | select ...} returning ..." statement of PostgreSQL style
  • Added "select ... for update" for support pessimistic lock by SQLite reserved lock
  • Added "show tables", "show columns", "show indexes", "show create table", "show create index" statements for querying schema information
Assets 3
Loading