Repl.it DB
Example test run for repl.it db
Working Form
Turn on explorer mode to use it!
Repl.it DB
Hello everyone! Repl.it just announced a new way to host your databases. They have created their own database type. It's unlike any other SQL/noSQL database: It is JSON based!!!
Links
Test run
Client code
NPM package
Github Code
Working "What do you think of node.js?" REPL
Node.js TUTORIAL
So, with help from
@masfrost, I have created an npm package for it! It contains the nativecurl functions, and includes more (like emptying database, setting automatic types for values and more!) Also along the way, I learned testing with jest...Also, I got the hacker plan!
Without further ado, here are the docs!
1) Click on the floppy disk:
This is the homepage for your database. You can view storage usage and amount of keys.
2) Click on the box icon:
Install replitdb-client.
3) Copy and paste this code into the editor (if all you want is a minimalistic template).
const Client = require("replitdb-client"); const client = new Client(); (async () => { // Add async/await methods here. })();
4) Now, you are ready to set some commands! Inside the async function, you can do some methods. For our tutorial, we will make a what do you think of the node.js engine survey.
Some quick docs
Setting data
await client.set("<key>", "<value>")
getting data
await client.get("<key>", { raw: true|false })
you can leave out the raw part, but if you set raw to false, you will either get an object, or an error (the data wasn't valid json)
listing keys
await client.list("<optional beginsWith>")
getting all data as an object
await client.getAll()
delete data
await client.delete("<key>")
delete all data
await client.empty()
Easy, right?
5) Prompt
Add this to your code:
const readline = require("readline"); const rl = readline.createInterface({ input: process.stdin, output: process.stdout }); rl.question("What do you think of node.js? ", async ans => { rl.question("What is your name? ", async name => { // TODO: Save to database }) })
This just gets our form ready. Remember the async because we are using await calls here.
6) Save to database
Quite easy. We just refer to our set method in the docs.
const Client = require("replitdb-client"); const client = new Client(); const readline = require("readline"); const rl = readline.createInterface({ input: process.stdin, output: process.stdout }); rl.question("What do you think of node.js? ", async ans => { rl.question("What is your name? ", async name => { // Save await client.set(name, ans); }) })
7) Get all data
Now, we can use client.getAll to accomplish this!
const Client = require("replitdb-client"); const client = new Client(); const readline = require("readline"); const rl = readline.createInterface({ input: process.stdin, output: process.stdout }); rl.question("What do you think of node.js? ", async ans => { rl.question("What is your name? ", async name => { // Save await client.set(name, ans); console.log("Thank you for your valuable input!"); console.log("Previous users have said:"); // Get all data let data = await client.getAll(); }) })
8) Parse the data
Right now our data is just an object, let's make it human-readable!
const Client = require("replitdb-client"); const client = new Client(); const readline = require("readline"); const rl = readline.createInterface({ input: process.stdin, output: process.stdout }); rl.question("What do you think of node.js? ", async ans => { rl.question("What is your name? ", async name => { // Save await client.set(name, ans); console.log("Thank you for your valuable input!"); console.log("Previous users have said:"); // Get all data let data = await client.getAll(); for (const user in data) { console.log(user, "has said", data[user]); } }) })
- And that's it! We have gone through almost all of what you will be using for a database (with delete as an exception). I can't wait to see what you will make with the client!
Also, here's the working code for you to hack ;)
Homework
- Make it so if the user entered a name that is already in the database, don't save to the database. (hint:
db.get) - Add colors!!
- Get a specific user's entry
Have a great day!
Ask in the comments below if you have any questions ;)
Is there a way to use repl.it db in HTML? Or to save any data from my website to a server? E.g. if I have a sign up page, how can I save accounts that have been created by users?
no it would not be secure nor feasible
you'd probably want to use repl auth and a mix of backend with that
@DrExperimentso there is a way of using a repl db in another repl with the db link from the .env file. but it seems like this link is updating like daily. do you maybe know a way to stop that? or do you know if it's maybe not allowed to use a repl db in more than one repl?
hope you can help me, pretty new to this and you seem to have a bit more knowledge on that haha
I don't even understand some of the details in this article, but there is some amazing information for me. I am aiming to build an engaging attractive website named wordle unlimited wordle and I got some ideas after reading this article. Thank you.
this is pretty cool
thank you!
@PolargamingWhenever someone else runs the code, it throws errors. Is there a way to prevent that?
btw I use python
no, because the error probably says something about the token not being defined, and the reason it isn't is because of security reasons. You probably want to make some sort of webserver instead
@Qwertyboi12I know this thing is pretty old but still wanted to ask. When I put the variable in which I use "new database" in "console.log" to see what it returns, I get a link. I examined the link for a while and I wanna if I can I use the link to access the DB from an HTML File.
hi
if you can access the link others can too -- and that is a security risk!
Also, for security too the link changes every so often
I have a few questions, and i am kinda new so sorry if that's dumb questions but...
- What type of data can you store in your database? I know you can do it with strings, but can you do it with integers, floats or booleans?
- The line to import the database in your example is :
const Client = require("replitdb-client");
However the line to import the database that repl gives me is :
const Database = require("@replit/database")
Does that mean that some stuff from the code is outdated? Or does your example still work?
- Can you create multiple databases in a single repl? I am trying to code a game in a discord bot that would remember both the gold the user has and the experience points won. I tried something like
const Database = require("@replit/database") //As in the insertable code const gold = new Database() const exp = new Database()
Would it be possible to manipulate both databases like that?
- [SOLVED] I don't know why but a lot of times the operations with the database are done out of order. For example, i have this program that's supposed to delete the database then add 2 values/keys and once it does so it logs them in the console :
const Database = require("@replit/database") //Import the database const db = new Database() //Create the database db.empty() //Clear the database db.set("key", "value").then(() => {});// Put a value and a key in the database. db.list().then(keys => {console.log(keys)}); //Logs all keys. I would like it to only log the key I added on the previous line db.set("otherkey", "othervalue").then(() => {}); //Adds another key and another value db.list().then(keys => {console.log(keys)}); //Logs the keys again. I would like it to log both keys I added on the previous lines
However, when I run it, the logs changes on every run, and I get sometimes this log :
[] [ 'key', 'otherkey' ]
Sometimes I get...
[ 'key', 'otherkey' ] [ 'key', 'otherkey' ]
And it changes exery time. What is the cause of that and how can I fix it? (Here is the repl's link : https://repl.it/@helloyanis/testdb#index.js )
Nevermind I solved it, jut had to add
.then(() => {});
after the line of code that clears the database. The link has the fixed code if someone wants it
- Any JSON serializable object.
- It only differs by name, this is an older tutorial, after replit adapted by library they must have changed how you defined things to be slightly more precise. There haven't been any breaking changes yet so it should be correct.
- psst don't do that one db client is good, but you can have multiple. It might cause some data races
@helloyanis
np!
did it help?
Technically Repl.it DB is NoSQL.
no, it's a key value database through and through.
After all, there is no 'collection' nor 'document', but you could align your db that way
Why am I still asking questions about this?
This has stumped me for a long, long time
How does the code know that the user is the same as name? And for the data[user], how does it know that that is ans??? (In this chunk of code):
for (const user in data) { console.log(user, "has said", data[user]); }
error undefined variable name and ans
I can't see the floppy disk even tho I'm in explorer mode...
Hey,
@coder100, i have found a problem with the delete function. If you delete an item, traces will still be left : result for getall is{'': null}
ah yes, I'll ask fluffin about that
@matthewproskilsyes, of course. Is there a problem?
@matthewproskilsyeah, but what's the problem
null is explicit undefined
undefined is well, undefined.
I cant figure out what client.get returns
hi hmmm idk maybe I should just make it happen by default lol
@ironblockhdWould you mind changing the implementation of getAll and setAll so it is more efficient? Currently, it waits for the fetching/setting the value for each key before continuning with the next key:
// getAll for (const key of data) { let value = await this.get(key); output[key] = value; } // setAll for (const key in obj) { let val = obj[key]; await this.set(key, val); }
This could be improved by using something like this:
// getAll const entries = await Promise.all(data.map(async key => [key, await this.get(key)])) const output = {} entries.forEach(([key, value]) => output[key] = value) return output // or with ES2019's Object.fromEntries: return Object.fromEntries(entries) // setAll await Promise.all(Object.entries(obj).map(([key, val]) => this.set(key, val)))
Hello. Thanks for your suggestion! Currently, I'm doing it this way is because of concerns about what the API can handle and not handle. Promise.all executes them all at the same time, while the await method will do it one-by-one. A bit slower, but until sid gets back,
this will be the implementation for now.
Nice, though, how do you get the floppy disk button?
Turn on explorer mode
@AmazingMech2418Oh no, coder100 is trying to topple my domain. Oh no must be better
Ah... couldn't find any documentation when I discovered it 24 hours ao yesterday morning
nice
@johnstev111what's the data base
what do you mean
@DynamicSquidOh i meant to say what is a data base. Like:
Hello everyone! Repl.it just announced a new way to host your databases. They have created their own database type. It's unlike any other SQL/noSQL database: It is JSON based!!!
like what are they referring to when they say database
noice!
thanks!
@TheForArkLDhello, repl.it db is to have persistent key/value data
why the mrlapiz GitHub lol?
um because that was the connected acc on desktop
@RohilPatelNice!
Thanks!
@randomlylelo
Omg, thats so cool! Now i finally can use a database that doesnt reset!
I made a wrapper for your wrapper haha
implemented in ironMedia now, ill give you credits of corse
nice!!!
@ironblockhd