SubhamSubhasisPatra/clickhouse_crud

How to make the crud operation with click house

How to make CRUD operation in Clickhouse DB

In the config add the name of the DB

const config = new ClickHouse({
  host: "clickhouse.msk",
  dataObjects: true,
  readonly: true,
  queryOptions: {
    profile: "web",
    database: "default", // name of the data base
  },
});

NOTE

Make sure click house is installed and clickhouse server is running ..

To run the application

git clone https://github.com/SubhamSubhasisPatra/clickhouse_crud.git
cd clickhouse_crud
npm ci
node populate.js // run this one first to load the data into db then
// then run the server.js file and uncomment the function that you want to use
node server.js