Stack Overflow
Stack Overflow

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
14
votes
2 answers

Real-time statistics: MySQL(/Drizzle) or MongoDB?

We are working on a project that will feature real-time statistics of some actions (e.g. clicks). On every click, we will log information like date, age and gender (these come from Facebook), location, etc. We are discussing about the best place to…
ItalyPaleAle
  • 7,185
  • 6
  • 42
  • 69
9
votes
1 answer

MariaDB vs Drizzle vs Percona Server vs MySQL

I've been a MySQL user for a long time now. I'd like to start using all the different variations between the most popular forks. The problem is that I can't find any good comparison between them, and I'll end up just trying all of them. My concerns…
santiagobasulto
  • 11,320
  • 11
  • 64
  • 88
9
votes
0 answers

Oracle's MySQL vs. MariaDB vs. Drizzle

I've used MySQL in the past but I have not touched it since around when Oracle bought Sun. Now that Oracle has began pushing out their own MySQL updates on the 5.x branch I've pondered the following: There is the Oracle branch as well as two popular…
Chris Abrams
  • 39,732
  • 19
  • 51
  • 57
7
votes
1 answer

Dispatch actions the proper way

Please, check the Edit I'm trying to implement sagas in my app. Right now I am fetching the props in a really bad way. My app consists mainly on polling data from other sources. Currently, this is how my app works: I have containers which have…
GeorgePal
  • 85
  • 6
3
votes
2 answers

Using Django with the Drizzle database?

Has anyone experience in using Django with the Drizzle database? The first GA version of Drizzle has just been released and from my understanding it should be be a good match for Django. Being a stripped down version of MySQL it still provides all…
dfoerster
  • 131
  • 6
2
votes
0 answers

Drizzle timestamp datenow invalid default value

I am new to Drizzle ORM and I am trying to make a simple schema where there is a created_at column that has default value of date of when did the account got created. This is the schema export const users = mysqlTable('users', { id:…
Parzival
  • 93
  • 6
2
votes
1 answer

Drizzle Columns Schema JSON stores my JSON as text in PostgreSQL

I'm using Drizzle for a Typescript backend that serves a few API endpoints. My database is Postgresql and there's a JSON column. export const transactions = pgTable("transactions", { id: serial("id").primaryKey(), my_json:…
pab
  • 150
  • 1
  • 11
2
votes
1 answer

Drizzle-Orm: How do you insert in a parent and child table?

New to SQL... how does one insert into a parent table and a child one? Assuming the following tables import { integer, pgTable, serial, text } from 'drizzle-orm/pg-core'; export const users = pgTable('user', { id: serial('id').primaryKey(), …
wongz
  • 3,255
  • 2
  • 28
  • 55
2
votes
1 answer

error during drizzle useCacheCall(): TypeError: Cannot read property 'methods' of undefined

I'm trying to invoke the drizzle useCacheCall() hook of a React Component from two different places. This is the invoked React component const FamilyContainer = ({ member }) => { console.log("inside family container, member: ", member); const {…
derper
  • 113
  • 8
2
votes
3 answers

Truffle Drizzle error "TypeError: Cannot read property 'address' of undefined"

Expected: After running the app, the user should see a "Loading Drizzle..." msg in the browser then soon followed by "Drizzle is ready". Results: The app stays stuck on "Loading Drizzle..." and there is an error in the chrome…
Leon Gaban
  • 36,509
  • 115
  • 332
  • 529
2
votes
3 answers

.NET/C# Drizzle database client

I am planning to use Drizzle in my next C# Mono app. Since there is no C# client available for Drizzle, I thought I would have a stab at writing my own by converting the Java client, and then making it work with DBLinq. Having seen the Java client,…
FlappySocks
  • 3,772
  • 3
  • 32
  • 33
2
votes
1 answer

Test Gearman/MySQL - Persistence Layer

Running Fedora, PHP/Gearman/MySQL/Drizzle. Built Gearman/Drizzle from source, and have the process running on a linux/fedora box. I created the mysql test table, and can see that the Gearman Daemon instance can access/interface with the mysql…
tom smith
  • 1,035
  • 7
  • 23
  • 39
1
vote
1 answer

Drizzle ORM: Infer type of schema including the relations

I am working on an Express App which uses Drizzle as ORM connected to Postgres Database. When I Infered the type of a specific schema, only the declared columns are added as attributes of the generated type. Is it possible to include the type for…
alas.code
  • 25
  • 4
1
vote
2 answers

Drizzle ORM not support Insert Returning

I have a question while working with Drizzle ORM and MySQL. Currently, Drizzle ORM does not provide insert returning function for MySQL. Check this link. My website adds users to the database and issues JWT tokens when they sign up. Since the…
Mason
  • 69
  • 7
1
vote
0 answers

Foreign key constraints not allowed using Drizzle ORM

I write the following schema in the Drizzle recommended syntax in order to initialise my project's database in PlanetScale (MySql). After completing the migration process and trying to npx drizzle-kit push:mysql, I got the following error: No config…
Braz
  • 73
  • 6
1
2 3 4