Skip to content

Latest commit

 

History

History

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 
 
 

README.md

Basic SQL Normalized

Table of contents

Introduction

A sample program that demonstrates how to perform CRUD operations on a NosDB collection through queries. This sample also utilizes the NosDB normalized data model.

This sample program demonstrates how to perform CRUD operations on a NosDB collection through queries. It utilizes the NosDB embedded data model. By using SQL INSERT, UPDATE and DELETE queries it shows how to perform Write Operation on NosDB and SQL SELECT to fetch the reader from NosDB.

This sample uses EntityObjects project as a reference for model class "Product".

Note: If you are unfamiliar with Git and GitHub, you can download the entire collection as a ZIP file.

Prerequisites

Before the sample application is executed make sure that:

  • Northwind sample data has been imported as explained in [BaseDir]\data\json\README.md.
  • Connection string in configuration.js is correct. For example, you need to provide correct database name and password.
  • NosDB Distributor Service (NosDistributorSvc) is running

Build and run the sample

Before starting the sample follow these steps: 1. Install node. 2. Install npm. 3. Northwind sample data has been imported as explained in [BaseDir]\data\json\README.md. 4. Make sure that all NosDB services are running including Distributor Service (NosDistributorSvc). 5. Use "npm install" command to install dependencies for Node.js sample. Make sure that path of dependencies is correct in 'package.json' file.

You are ready to start the sample application.

Additional Resources

Documentation

The complete online documentation for NosDB is available at: http://www.alachisoft.com/resources/docs/#nosdb

Programmers' Guide

The complete programmers guide of NosDB is available at: http://www.alachisoft.com/resources/docs/nosdb/nosdb-programmers-guide.pdf

Technical Support

Alachisoft © provides various sources of technical support.

Copyrights

© Copyright 2017 Alachisoft.