Skip to content
Sign upLog in
← Back to Community

Repl.it Database / External use

Profile icon
IlexisTheMadcat

Hello, I want to migrate my discord bots to running on my personal local server, however I still want to use an online database.
I've had good luck with using the replit database, and I know how to get the URL of it, but how can I interact with my database on my computer within an async python script?
I do not want to use pickle or a local JSON (I can use a local JSON if there are no other options). My only intention with the database is to overwrite it with the local one, as to save it to the cloud.

Voters
Profile icon
IlexisTheMadcat
Comments
hotnewtop
Profile icon
LordOfAllPie

Start with this in a Repl (replit):

from os import getenv print(getenv("REPLIT_DB_URL"))

Now that we have your db url, use this in your computer's IDE:

from os import environ environ["REPLIT_DB_URL"] = "<INSERT YOUR DB URL FROM ABOVE HERE>" from replit import db

You can now use it on your local machine with that file.

Profile icon
Coder100
print(os.getenv("REPLIT_DATABASE_URL"))

use this and copy the url that is printed.
Afterwards, u just need to add this to the database:

from replit import db db.db_url = "<...>"

**notes: ** Replit database was made specifically for replit, this is not an ideal solution, and there is no perfect solution.
For security, the database url is reset every once in a while, so you will have to update the url each time the url doesn't work anymore.

Profile icon
IlexisTheMadcat

@Coder100
will this work at least to perform the dictionary updates when I do anything to db?

Profile icon
Coder100

yeah, sure it will

@SUPERMECHM500

Profile icon
IlexisTheMadcat

@Coder100
ok i will export to my local machine and try this

Profile icon
Coder100

gl

@SUPERMECHM500

Profile icon
IlexisTheMadcat

@Coder100

image

I do not think it will work...

Profile icon
Coder100

hm
i guess the lib just doesn't want to work outside of replit environments, that's kind of expected unfortunately.

@SUPERMECHM500

Profile icon
19wintersp

@Coder100
@SUPERMECHM500
I built a GUI editor for ReplDB; if you have Java 14 or above, you can download and run it.