Learn to Code via Tutorials on Repl.it!

← Back to all posts
Repl.it DB
h
Coder100 (4061)

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 native curl 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]);
    }
  })
})

9) 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 ;)

Commentshotnewtop
matthewproskils (289)

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}
rediar (309)

I cant figure out what client.get returns

ironblockhd (173)

@Coder100 just a warning, use encode/decodeURIComponent for your next project with your database, i just found out why mine broke like once a week

Coder100 (4061)

hi hmmm idk maybe I should just make it happen by default lol @ironblockhd

cherryblossom00 (0)

Would 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)))
Coder100 (4061)

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. @cherryblossom00

HahaYes (1021)

wat no sql....
First actual...

HAHAYES

AmazingMech2418 (691)

Nice, though, how do you get the floppy disk button?

ironblockhd (173)

Omg, thats so cool! Now i finally can use a database that doesnt reset!

ironblockhd (173)

I made a wrapper for your wrapper haha

ironblockhd (173)

implemented in ironMedia now, ill give you credits of corse

HahaYes (1021)

Oh no, coder100 is trying to topple my domain. Oh no must be better

HahaYes (1021)

@Coder100 Hehe I rule the memes therefore I rule REPL

Bookie0 (3220)

wait you keep repeating that... what memes do you rule? @HahaYes

Coder100 (4061)

oh he rules the tutorial section apparently @Bookie0

firefish (306)

Ah... couldn't find any documentation when I discovered it 24 hours ao yesterday morning

firefish (306)

@Coder100 That's one day old. A more up-to-date version would be 56 hours ago.

DynamicSquid (2619)

what's the data base

DynamicSquid (2619)

@Coder100
Oh 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

TheForArkLD (650)

@Coder100 btw
repl.it db is for collect other programmers info?
btw
can we do Stekovaya?

Coder100 (4061)

hello, repl.it db is to have persistent key/value data @TheForArkLD

TheForArkLD (650)

@Coder100 can not invited user set data?

TheForArkLD (650)

@Coder100 btwwwwwww can we do stekovaya?

firefish (306)

@TheForArkLD If he doesn't he doesn't. And?

firefish (306)

@TheForArkLD Yes, but it has to be stored in JSON. You key/value pairs only.

firefish (306)

@TheForArkLD Erm... what did you say OK to?

RohilPatel (802)

why the mrlapiz GitHub lol?

Coder100 (4061)

um because that was the connected acc on desktop @RohilPatel