create table object_class ( id int(10) unsigned not null auto_increment, create_time datetime not null default current_timestamp, name varchar(255) default null, scope varchar(100) default null, code varchar(100) not null, primary key(id) ) en
``` CREATE TABLE IF NOT EXISTS `txt` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `hash` binary(32) NOT NULL, `val` longtext DEFAULT NULL, PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */, UNIQUE KEY `hash` (`hash`) ); ```
MySQL adapter for @atscript/db with mysql2 driver support.
``` CREATE TABLE IF NOT EXISTS `txt` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `hash` binary(32) NOT NULL, `val` longtext DEFAULT NULL, PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */, UNIQUE KEY `hash` (`hash`) ); ```
Multi-chain sweep and paymaster SDK: EVM, Solana, Tron. Gasless transactions for your users.
SBVR type definitions.
Generate a full Express + React CRUD project from SQL CREATE TABLE statements.
[test/main.coffee](./test/main.coffee) :
Implements a log table for an SQL app.
MySQL easy model, easy query. easy typing! Auto generate typescript declaration.
Multi-chain sweep and paymaster SDK: EVM, Solana, Tron. Gasless transactions for your users.
NodeJS SQL query builder
nestjs common admin crud module controller service
Parse and convert SQL DDL statements to a JSON Schema.
Connect to MariaDB, extract schema, run analysis and queries
KeystoneJS AutoIncrement Field Type
Wiki your codes and Markdown your project each time when you submit your code to svn.
# Syntex:
Multi dialect ORM for Node.JS/io.js
An Object-relational mapping for the Master framework. Master Record connects classes to relational database tables to establish a database with almost zero-configuration
KeystoneJS AutoIncrement Field Type
nestjs common admin crud module controller service
Functions to persist authentication state to a RDMS via knex
NestJS module to log request/response to mysql database
Provides an ergonomic way to define data models that are seamlessly converted into IndexedDB object stores, utilizing derive macros
Provides an ergonomic way to define data models that are seamlessly converted into IndexedDB object stores, utilizing derive macros
A MyBatis-plus-like ORM library for Rust with reflection, support sqlite, mysql, postgre, oracle and mssql.
A tool to compare two databases and generate a diff for MariaDB.
A reflection library for Rust based on derive macros, providing runtime field access capabilities for structs.
Safe, easy-to-use auto-increment integers
Code generator for sqlxplus
Switchy database package
A lightweight, SQL-friendly ORM for Rust
Procedural macros for litedbmodel
Procedural macros for TideORM
database diff checker
Automaticaly increments an ActiveRecord column
Add SQL like auto-incrementing fields to your Mongoid documents.
Let you define an auto-incremented field in Mongoid, which will behave like SQL id field.
This gem for change Mongoid id field as Integer like MySQL.
This gem for change Mongoid id field as Integer like MySQL.
Use Mysql AUTO_INCREMENT to support key value cache, which should be combined by an integer and string. It means to reduce the database storage size, and improve query performance. All cache will store in process memory, and will never be expired, until the process dies, so the less kvs you use, the better performance you will get. BTW, 100,000 general strings use 10MB memory. Some relatived articles: http://en.wikipedia.org/wiki/Correlation_database Usage ------------------------------------------ ## setup ```ruby create_table :kv_browser_names, :options => 'ENGINE=MyISAM DEFAULT CHARSET=utf8' do |t| t.string :name t.timestamps end class KvBrowserName < ActiveRecord::Base include IdNameCache end ``` or ```ruby create_table :common_tag, :options => 'ENGINE=MyISAM DEFAULT CHARSET=utf8' do |t| t.integer :tagid t.string :tagname end class CommonTag < ActiveRecord::Base self.table_name = :common_tag self.primary_key = :tagid include IdNameCache; set_key_value :tagid, :tagname # include IdNameCache; set_key_value_without_create :tagid, :tagname # if you dont want create it automately end ``` ### use cases ```text ruby-1.9.3-rc1 :001 > QuizTag[1] QuizTag Load (0.3ms) SELECT `common_tag`.* FROM `common_tag` WHERE `common_tag`.`tagid` = 1 LIMIT 1 => "Android" ruby-1.9.3-rc1 :002 > QuizTag[1] => "Android" ruby-1.9.3-rc1 :003 > QuizTag['Android'] QuizTag Load (0.5ms) SELECT `common_tag`.* FROM `common_tag` WHERE `common_tag`.`tagname` = 'Android' LIMIT 1 => 1 ruby-1.9.3-rc1 :004 > QuizTag['Android'] => 1 ``` == Copyright MIT, David Chen at eoe.cn
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.