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
0
votes
0 answers

Getting an error when trying to set up Turso database

I follow this tutorial to set up a web app using Bun, Htmx, Turso and Elysium. The problem is trying to set up the database. I created my account and put the database URL and auth token in .env file, but I couldn't get it to work, even with the…
0
votes
1 answer

drizzle-orm with multiple many-to-one relations - Please specify relation name at normalizeRelation

I have two tables and two relations that I have defined as follows: export const games = pgTable('games', { id: serial('id').primaryKey(), player1Id: integer('player1_id'), player1Scores: json('player1_scores'), player2Id:…
Sebastian
  • 951
  • 6
  • 21
0
votes
0 answers

Error: Type '() => Promise<{}[]>' is not assignable to type '{}[]'. How do I fix this in DrizzleORM?

Hi I am using DrizzleORM with Neon as DB on Nextjs. The error: Type '() => Promise<{ deptno: string; deptname: string; mgrno: string | null; topdep: boolean | null; admrdept: string; location: string | null; }[]>' is not assignable to type '{…
0
votes
1 answer

How to represent 'bytea' datatype from pg inside new drizzle orm?

Im trying to learn new drizzle orm for node js, and im here trying to create a small auth database to see how the orm works. using 'pnpm drizzle-kit generate:pg' i generated a schema from a pg database, but bytea datatype was not parsed to ts. as…
0
votes
1 answer

Drizzle ORM with Postgres: error - unhandledRejection: error: no schema has been selected to create in

Using pg-core with "drizzle-orm": "^0.25.2", and my following db.ts looks like the following: // db.ts import { drizzle } from "drizzle-orm/node-postgres"; import { migrate } from "drizzle-orm/node-postgres/migrator"; import { Pool } from…
wongz
  • 3,255
  • 2
  • 28
  • 55
0
votes
1 answer

Should I use Postgresql or MySQL for a new project with Drizzle on the horizon?

Since Oracle has MySQL and now is working on Drizzle, for a new project should I choose Postgres? I need a free database and though I've always used MySQL in the past, I'm concerned about it now. Drizzle isn't hosted in a lot of places like MySQL…
johnny
  • 19,272
  • 52
  • 157
  • 259
0
votes
1 answer

Unable to setup the drizzle vue plugin with the vuejs 2

I have setup the drizzle with vuejs 2 using official documentation here. When I try running the project with yarn serve I am getting the following errors For the fix, I tried installing all the packages. Unfortunately it didn't work for me
tbhaxor
  • 1,659
  • 2
  • 13
  • 43
0
votes
1 answer

Reading a tuple from contract with Drizzle

Using ContractData from drizzle/react-components to try and call a read function that returns multiple parameters from a struct MyComponent.js

Get Participant Details

slugz
  • 1
  • 1
0
votes
0 answers

Truffle Drizzle Tutorial fails on last step 'npm run dev'

I am on windows 10, using vscode. Basically finished the petshop tutorial with no issues or problems using truffle. when I enter the command npm run dev it fails as shown below. PS Y:\code\petshop> npm run dev > pet-shop@1.0.0 dev >…
0
votes
1 answer

React Drizzle ContractForm interacting with method with multiple parameters

I want to use the React Drizzle contract form to display a form that can take multiple data elements i.e. will display an input box for name and nationality. So this is a simple example that slightly expands on the set and get methods on the drizzle…
chucknor
  • 837
  • 2
  • 18
  • 33
0
votes
1 answer

Error: Returned error: VM Exception while processing transaction: out of gas

I have a simple smart contract deployed on the local truffle env using migrate. I am using react-components package to work with the smart contract. So my issue is that simple getters and setters are working, but when I try to run a method with 2-3…
srinivas
  • 4,778
  • 2
  • 32
  • 43
0
votes
0 answers

Web3.utils.hexToUtf8 getting "undefined" error

I am trying to return an username from a struct inside a mapping and I am getting this error: Error: The parameter "undefined" must be a valid HEX string. contract UserStorage is BaseStorage { event UserCreated(string _message); struct…
0
votes
1 answer

How do I fetch an array from a smart contract using cacheCall()?

Let's say I have an array in my smartcontract that looks like this string[] public employees; I am able to fetch data from employees if I know the index, like this contract.method["employees"].catchCall([i]); // i is the index How am I supposed to…
Divyanth Jayaraj
  • 950
  • 4
  • 12
  • 29
0
votes
1 answer

Pip installation causes RecursionError

I am trying to install a software called grizli (https://github.com/gbrammer/grizli/) in a conda environment. In one step I have to install another software called drizzle (https://github.com/gbrammer/drizzle.git). Thís installation always results…
0
votes
1 answer

No such column in Drizzle JDBC

Now Iam using Drizzle drizzle-jdbc-1.1 instead of mysql-connector-java-5.1.12. But when reading data from my table, it shows an error like this. But this issue is present only when using drizzle-jdbc and the query successfully works with mysql-jdbc.…
Haseena
  • 484
  • 2
  • 11
  • 25