Skip to content
#

sqlite3

Here are 4,822 public repositories matching this topic...

yodhcn
yodhcn commented Feb 13, 2021

Feature request

Is there any chance to have a Knex native way to set "DEFERRABLE INITIALLY DEFERRED" on a table with foreign key constraints ?

knex.schema.table('users', function (table) {
  table.integer('user_id').unsigned()
  table.foreign('user_id').references('Items.user_id_in_items').deferred().
})
mikro-orm
jasonwilson
jasonwilson commented May 4, 2021

Is your feature request related to a problem? Please describe.
In trying to setup a new database from an initial migration I realized there's no way to create a new database from scratch. Is that accurate?

Describe the solution you'd like
Something akin to rake db:init or rake db:create where mikro-orm will take the runtime config and create a new database if it doesn't exist

siscia
siscia commented May 5, 2019

RediSQL support multiple statements in the same "EXEC", hence it is possible and correct to do something like:

REDISQL.EXEC DB "INSERT INTO foo VALUES(1,2,3); INSERT INTO bar VALUES(2,3,4);" 

Which is quite convenient when mixed with BEGIN, COMMIT and ABORT instruction.

One problem is that all the statements are first prepared all together, and then executed, all together.

This

C++高性能分布式服务器框架,webserver,websocket server,自定义tcp_server(包含日志模块,配置模块,线程模块,协程模块,协程调度模块,io协程调度模块,hook模块,socket模块,bytearray序列化,http模块,TcpServer模块,Websocket模块,Https模块等, Smtp邮件模块, MySQL, SQLite3, ORM,Redis,Zookeeper)

  • Updated Nov 2, 2020
  • C++
vscode-sqltools

Improve this page

Add a description, image, and links to the sqlite3 topic page so that developers can more easily learn about it.

Curate this topic

Add this topic to your repo

To associate your repository with the sqlite3 topic, visit your repo's landing page and select "manage topics."

Learn more