Node Crate: A Comprehensive Guide to Efficient Database Operations

Node Crate is an incredibly powerful Node.js client for interacting with CrateDB, a distributed SQL database. This guide will walk you through various APIs provided by Node Crate, with detailed explanations and code snippets to help you integrate it seamlessly into your application.

Installation

npm install node-crate

Connecting to CrateDB

Establishing a connection to CrateDB is straightforward. Below is an example of how to do it:

  const Crate = require('node-crate');
  
  Crate.connect('http://localhost:4200');

Creating a Table

Creating tables is simple. Here’s how you can use Node Crate to create a table:

  Crate.execute("CREATE TABLE articles (id INT, title STRING, content STRING)")
    .then(res => console.log('Table created successfully!'))
    .catch(err => console.error('An error occurred: ', err));

Inserting Data

Inserting data into your CrateDB table can be done as follows:

  Crate.insert('articles', { id: 1, title: 'First Article', content: 'This is the content of the first article.' })
    .then(res => console.log('Data inserted successfully!'))
    .catch(err => console.error('An error occurred: ', err));

Retrieving Data

Query your CrateDB to retrieve data using:

  Crate.execute("SELECT * FROM articles")
    .then(data => console.log('Data retrieved:', data.json))
    .catch(err => console.error('An error occurred: ', err));

Updating Data

Update existing data within your table:

  Crate.execute("UPDATE articles SET title = 'Updated Article' WHERE id = 1")
    .then(res => console.log('Data updated successfully!'))
    .catch(err => console.error('An error occurred: ', err));

Deleting Data

Delete data from your table:

  Crate.execute("DELETE FROM articles WHERE id = 1")
    .then(res => console.log('Data deleted successfully!'))
    .catch(err => console.error('An error occurred: ', err));

App Example: CRUD Operations

Here is a simple CRUD application example using Node Crate:

  const express = require('express');
  const Crate = require('node-crate');

  Crate.connect('http://localhost:4200');
  const app = express();
  app.use(express.json());

  // Create a new article
  app.post('/articles', (req, res) => {
      const { id, title, content } = req.body;
      Crate.insert('articles', { id, title, content })
          .then(result => res.status(201).send('Article created'))
          .catch(err => res.status(500).send(err));
  });

  // Retrieve all articles
  app.get('/articles', (req, res) => {
      Crate.execute('SELECT * FROM articles')
          .then(data => res.send(data.json))
          .catch(err => res.status(500).send(err));
  });

  // Update an article
  app.put('/articles/:id', (req, res) => {
      const { id } = req.params;
      const { title, content } = req.body;
      Crate.execute(`UPDATE articles SET title = '${title}', content = '${content}' WHERE id = ${id}`)
          .then(result => res.send('Article updated'))
          .catch(err => res.status(500).send(err));
  });

  // Delete an article
  app.delete('/articles/:id', (req, res) => {
      const { id } = req.params;
      Crate.execute(`DELETE FROM articles WHERE id = ${id}`)
          .then(result => res.send('Article deleted'))
          .catch(err => res.status(500).send(err));
  });

  app.listen(3000, () => console.log('Server running on port 3000'));

With these APIs and this example application, you can perform various database operations efficiently using Node Crate. Explore more and integrate it seamlessly into your workflows!

Hash: 117ce5cf0d6be793da2886d9b8474ad9ada85940e36df08aef9d6a789391a7fe