Category: Database

Create a REST API with Node.js, Express, and MongoDB

Creating a REST API with Node.js is simple, fast, and efficient. Node.js is lightweight, non-blocking, and perfect for data intensive applications. Node.js, although young, has a strong community backing. The Node.js community provides a vast array of modules that can be leveraged to simplify the implementation process. Node.js also has support for many widely used offerings. In this post, we will use MongoDB with Node.js. We will also use two...

Java Stored Procedures with Derby

Stored procedures provide a very powerful capability. They enable the execution of many SQL statements within the context of conditional programming logic, via a single database call. Stored procedures execute in the database, thus making them an excellent place for computationally intense db operations. Stored procedures do come at cost. Some database vendors offer extensions to SQL e.g. PL/SQL, T-SQL, PL/pgSQL . These extensions may be proprietary or may comform...

Quick Start with Apache Derby

Download and Install Derby Download the Apache Derby database. Note: At the time of this post, I am using version 10.10 To install, simply unpack the download to your favorite directory. We’ll refer to this directory as $DERBY_HOME Start Derby server $DERBY_HOME/bin/startNetworkServer Connect to Derby Run Derby’s interactive SQL tool: $DERBY_HOME/bin/ij ij>connect ‘jdbc:derby://localhost:1527/sample-db;create=true;user=APP;password=APP’; Note: This command will connect to the Derby server running on localhost on Derby’s default port, 1527. create=true will...