Skip to content

A system where users can modify wave data. The system contains an Express server, SQL Server, Apache Cassandra, and DynamoDB.

License

Notifications You must be signed in to change notification settings

sagedemage/wave_data_system

Repository files navigation

wave_data_system

A system where users can modify wave data. The system contains an Express server, SQL Server, Apache Cassandra, and DynamoDB.

Wave Data System

Setup

Install dependencies

npm install

Copy the sample-env file to .env

cp sample-env .env

Start back-end server

npm start

Run SQL Server container

docker compose up

Run in the background

docker compose up -d

SQL Server Setup

Use a database management program to manage and administer SQL Server. My recommendation is DBeaver because it works on Linux.

Create a database called radio_waves in SQL Server.

Docker CLI

Remove docker container

docker container rm -f -v 6c0d86736da5

Check that the Cassandra container is running

docker exec 86dcd74e5666 nodetool status

CQL Queries

Go to the Cassandra container with the cqlsh command to get into the Cassandra shell

docker exec -it 86dcd74e5666 cqlsh

Show a list of tables

describe tables;

Get the logs and its information

select * from logger."Log";

Delete a keyspace

drop keyspace logger;

Docker Desktop

Set the Memory Limit to 6 GB in Settings → Resources. This is necessary to avoid the insufficient system memory issue.

Setup DynamoDB on AWS

Create a table called "LoginLogs". It has a Partition key called "logid" with String as its type.

Table name: LoginLogs

Partition key:

  • logid: String

Attributes:

  • msg: String
  • created: String

Resources

About

A system where users can modify wave data. The system contains an Express server, SQL Server, Apache Cassandra, and DynamoDB.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published