Questions tagged [drizzle]

Drizzle is a transactional, relational, community-driven open-source database that is forked from the popular MySQL database.

Drizzle is a transactional, relational, community-driven open-source database that is forked from MySQL.

The Drizzle team has removed non-essential code, has re-factored the remaining code, and has converted the code to modern C++ and modern libraries.

Charter

  • A database optimized for Cloud infrastructure and Web applications
  • Design for massive concurrency on modern multi-CPU architectures
  • Optimize memory use for increased performance and parallelism
  • Open source, open community, open design

Scope

  • Re-designed modular architecture providing plugins with defined APIs
  • Simple design for ease of use and administration
  • Reliable, ACID transactional
47 questions
1
vote
0 answers

How to best manage migrations with Drizzle ORM in a Monorepo?

How do you best manage/execute database migrations if the same database is being used within multiple projects? Some background: I have a project with a monorepo structure build with Turborepo on top of npm workspaces. In the repo I have an internal…
benjiman
  • 3,888
  • 4
  • 29
  • 44
1
vote
0 answers

Drizzle Components in React App - can not read properties of undefined. Above statement occured in component

I am trying to use Drizzle inside a React App to show the smart contract details in the front end. However stuck at this error, which says drizzle-react-components.js:1 Uncaught TypeError: Cannot read properties of undefined…
BlockChain Learner
  • 125
  • 1
  • 10
  • 18
1
vote
0 answers

How to send multiple function arguments to solidity smart contract from react.js?

I am trying to call a function of solidity contract that takes in multiple arguments(8 arguments). This is my contract function. function generatePet( uint256 _petPrice, string memory…
sultan
  • 379
  • 1
  • 5
  • 20
1
vote
1 answer

Drizzle npm install error with node scrypt@6.0.3 install and node-gyp rebuild

When you try to install drizzle: npm install drizzle it fails when node version mismatches and there are some unresolved lib dependencies with errors: In file included from ../src/node-boilerplate/inc/scrypt_async.h:28: …
srinivas
  • 4,778
  • 2
  • 32
  • 43
1
vote
1 answer

Drizzle installation end up with errors

I have followed the this tutorial from Truffle official page, First few steps goes smoothly and when i tried to install drizzle on client directory as per the tutorial says it ended up with this error message, before this error message it has…
pl-jay
  • 970
  • 1
  • 16
  • 33
1
vote
3 answers

Get current account selected in Metamask using Drizzle

How to (in Drizzle) get the account currently selected in Metamask? I have a function to call a method set of the smart contract, but currently account is "hardcoded": setValue = value => { const { drizzle, drizzleState } = this.props; …
shogitai
  • 1,823
  • 1
  • 23
  • 50
1
vote
0 answers

Zero DateTime Behavior with Dizzle JDBC Driver

I have a MySQL database connected to my application with the Drizzle MySQL-connector. This database has a table with a DateTime column that can have the value 0000-00-00 00:00:00. Now I want to get some data: TypedQuery query =…
klausf
  • 289
  • 2
  • 8
1
vote
1 answer

Does gearmand with libdrizzle work while mysql-database is down for a while?

Use-Case: The gearmand is fully operational with libdrizzle as persistence-layer to a mysql-database The drizzle connection crashes (e.g. the gearmand-database is locked for some minutes during nightly backups, or the mysql server crashes or…
itinance
  • 11,711
  • 7
  • 58
  • 98
1
vote
1 answer

Could not ping, broken pipe in MariaDB Drizzle JDBC

I have an java application which uses mariadb server. From java, drizzle jdbc is used for connecting the mariadb server. Sometimes, I got an error, broken pipe. I don't know why this error occured, its root cause. Iam using ubuntu12.04, latest…
Haseena
  • 484
  • 2
  • 11
  • 25
0
votes
2 answers

renumber(set column to rank) a column after order by on that column

in sql, i want to do something like update table set col = rank(col) order by col how do i do this ? Purpose : currently the col has extreme values, like -14000, 23, 4000, 23000 ... they are used in asc, desc sort but when i plot them on a slider,…
Pheonix
  • 6,049
  • 6
  • 30
  • 48
0
votes
0 answers

Reference a type outside a block

I have a type inside a block, but I want to reference it from an external block. In this example I have a drizzle ORM query which generates a well defined type, which I want to use in the calling function: function a() = { const emisor =…
Ben Quan
  • 773
  • 11
  • 25
0
votes
1 answer

Drizzle ORM - decimal MySQL is a string?

The schema: export const myTable = mysqlTable( "MyTable", { id: varchar("id", { length: 191 }).notNull(), value: decimal("value", { precision: 7, scale: 4 }).notNull(), createdAt: datetime("createdAt", { mode: "date" }) …
Alan Sikora
  • 497
  • 5
  • 11
0
votes
0 answers

Drizzle-Kit geneate:pg give error SyntaxError: Cannot use import statement outside a module

drizzle-kit generate:pg --out migrations-folder --schema src/db/schema.ts I run the above command to generate migration with drizzle but it give the below error drizzle-kit: v0.19.12 drizzle-orm: v0.28.1 /media/chirag/DATA/Streaming…
0
votes
0 answers

PostgreSQL migration issue in AWS RDS with Drizzle ORM: 'no pg_hba.conf entry for host' error

I've been using drizzle for a new project over the past few weeks, and it has provided a great developer experience. Now, it's time to bring the app to production. However, I'm currently facing an issue with the migrations. The app is deployed in…
0
votes
1 answer

TypeScript type error with drizzle-orm and zod validation

I am currently working on a project that involves using drizzle-orm and zod for validation in a TypeScript environment. My issue arises from the interaction between these two libraries, specifically when dealing with the InsertOrderType type…
hantoren
  • 357
  • 2
  • 17