Skip to content
#

sqlite3

Here are 4,825 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
JoelVenable
JoelVenable commented May 16, 2021

Issue: AWS RDS database instances support short-lived credentials via IAM Authentication. This pattern is more secure, since the database password is generated from the IAM role and expires after 15 minutes. Therefore, a database password does not even need to be passed into the execution environment at all. I suspect other cloud providers incorporate similar functionality.

https://docs.aws

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 May 17, 2021
  • 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