Drizzle Team•3w ago

Drizzle Studio stuck at 'connecting to localhost:4983'

I have a local Ubuntu server with Docker & Coolify running my websites. I'd like to install Drizzle Studio so I can have that nice interface with my databases instead of going at it through command-line (ugh, last time I messed with databases was like 15 years ago through phpMyAdmin). I'm a little bit confused on how to get it up and running on my machine, I was under the impression it would be just a simple web app that I throw into my docker and connect via the port. Need some guidance

46 Replies

Mario564•3w ago

Drizzle Studio can be deployed using Drizzle Gateway, which is a containerized version of Studio. It has a free trial and then you have to pay $20/year for it. https://github.com/orgs/drizzle-team/packages/container/package/gateway There isn't a lot of documentation around it right now, but you can discuss this product further in #gateway if you need any help or want to provide feedback

Don Cezar•3w ago

Yeah something paid is not what I'm looking for, basically I just want an interface that I can use to edit tables instead of via command line or code

Mario564•3w ago

Other than what I mentioned, there's no other way to securely deploy Drizzle Studio

Don Cezar•3w ago

The docs show a way to run it via npm, what's so different about gateway and why does it cost money if it's self-hostable

Mario564•3w ago

Once you run it, you'll be asked to sign into Github and from there you sign up for the free trial If you want more information, you could ask one of the official Drizzle Team members

Don Cezar•3w ago

So there's absolutely no way to run Drizzle Studio for free? Why do you even need github for it?

Mario564•3w ago

1. Nope. You might be able to deploy it for free without Docker but there's no security measures preventing random people from using the interface. 2. It's nothing to do with the Studio interface, it's for the account you pay with.

Don Cezar•3w ago

1. How do I deploy it without Docker, free? I don't care about security, it will be only on localhost

Mario564•3w ago

You could take a look at the "Launch Drizzle Studio" section of this page https://orm.drizzle.team/drizzle-studio/overview

Drizzle ORM - Meet Drizzle Studio

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

Don Cezar•3w ago

It doesn't seem to work, stuck at loading. Followed the drizzle-kit installation:

cezar@ubuserver:~/drizzle$ npm i -D drizzle-kit

up to date, audited 32 packages in 1s

2 packages are looking for funding
  run `npm fund` for details

found 0 vulnerabilities
cezar@ubuserver:~/drizzle$ drizzle-kit studio
drizzle-kit: command not found

cezar@ubuserver:~/drizzle$ npm i -D drizzle-kit

up to date, audited 32 packages in 1s

2 packages are looking for funding
  run `npm fund` for details

found 0 vulnerabilities
cezar@ubuserver:~/drizzle$ drizzle-kit studio
drizzle-kit: command not found

Don Cezar•3w ago

If I use npx before drizzle-kit studio, Drizzle Studio starts but.. it gets stuck at connecting 😅

cezar@ubuserver:~/drizzle$ npx drizzle-kit studio
No config path provided, using default 'drizzle.config.ts'
Reading config file '/home/cezar/drizzle/drizzle.config.ts'
Using 'pg' driver for database querying

 Warning  Drizzle Studio is currently in Beta. If you find anything that is not working as expected or should be improved, feel free to create an issue on GitHub: https://github.com/drizzle-team/drizzle-kit-mirror/issues/new or write to us on Discord

Drizzle Studio is up and running on https://local.drizzle.studio

cezar@ubuserver:~/drizzle$ npx drizzle-kit studio
No config path provided, using default 'drizzle.config.ts'
Reading config file '/home/cezar/drizzle/drizzle.config.ts'
Using 'pg' driver for database querying

 Warning  Drizzle Studio is currently in Beta. If you find anything that is not working as expected or should be improved, feel free to create an issue on GitHub: https://github.com/drizzle-team/drizzle-kit-mirror/issues/new or write to us on Discord

Drizzle Studio is up and running on https://local.drizzle.studio

Mario564•3w ago

What browser are you using?

Don Cezar•3w ago

Tried multiple - Vivaldi, Edge, Chrome npx drizzle-kit push connected to the database and created the table so pg is not an issue I even installed mkcert and it's still not connecting

Mario564•3w ago

Hmm, can I see your Drizzle config file?

Don Cezar•3w ago

It's the one from the guide

import { defineConfig } from "drizzle-kit";
 
export default defineConfig({
  schema: "./schema/*",
  out: "./drizzle",
  dialect: 'postgresql',
  dbCredentials: {
    url: process.env.DB_URL,
  }
});

import { defineConfig } from "drizzle-kit";
 
export default defineConfig({
  schema: "./schema/*",
  out: "./drizzle",
  dialect: 'postgresql',
  dbCredentials: {
    url: process.env.DB_URL,
  }
});

Gaming

Programming

Drizzle Studio stuck at 'connecting to localhost:4983'