Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Coffeescript Application Development Cookbook
  • Table Of Contents Toc
Coffeescript Application Development Cookbook

Coffeescript Application Development Cookbook

By : Hatfield
4.6 (5)
Buy this Book
close
close
Coffeescript Application Development Cookbook

Coffeescript Application Development Cookbook

4.6 (5)
By: Hatfield
Buy this Book

Overview of this book

If you are interested in developing modern applications, this book will help you leverage the vast JavaScript ecosystem while using an elegant language, helping you avoid the shortcomings of JavaScript.
Table of Contents (13 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Getting Ready
Icon
1. Getting Ready
Icon
Introduction
Icon
Configuring your environment and tools
Icon
Configuring Sublime Text
Icon
Configuring Visual Studio
Icon
A quick dive into CoffeeScript
Icon
Debugging CoffeeScript using source maps
Icon
Debugging CoffeeScript using Node Inspector
2
2. Starting with the Basics
Icon
2. Starting with the Basics
Icon
Introduction
Icon
Working with strings
Icon
Working with numbers
Icon
Working with dates and times
Icon
Working with arrays
Icon
Working with classes
Icon
Dealing with the this keyword
3
3. Creating Client Applications
Icon
3. Creating Client Applications
Icon
Introduction
Icon
Working with jQuery
Icon
Working with Backbone
Icon
Working with AngularJS
Icon
Communicating in real time with Socket.io
4
4. Using Kendo UI for Desktop and Mobile Applications
Icon
4. Using Kendo UI for Desktop and Mobile Applications
Icon
Introduction
Icon
Using the Kendo UI Core widgets
Icon
Using the Kendo UI Core mobile widgets
5
5. Going Native with Cordova
Icon
5. Going Native with Cordova
Icon
Introduction
Icon
Creating a basic Cordova application
Icon
Using the camera
Icon
Using geolocation
Icon
Using contacts
Icon
Getting device information
6
6. Working with Databases
chevron up
Icon
6. Working with Databases
Icon
Introduction
Icon
Working with SQLite
Icon
Working with Redis
Icon
Working with MongoDB
Icon
Working with CouchDB
7
7. Building Application Services
Icon
7. Building Application Services
Icon
Introduction
Icon
Working with base64 encoding
Icon
Working with domain name services
Icon
Parsing a URL into its various components
Icon
Creating RESTful web services
8
8. Using External Services
Icon
8. Using External Services
Icon
Introduction
Icon
Working with web services
Icon
Sending e-mail
Icon
Sending SMS and MMS messages
Icon
Working with Amazon's S3 storage
Icon
Transferring files via FTP
9
9. Testing Our Applications
Icon
9. Testing Our Applications
Icon
Introduction
Icon
Unit testing with QUnit
Icon
End-to-end testing with Mocha and Zombie.js
Icon
Stubbing and mocking with Sinon
10
10. Hosting Our Web Applications
Icon
10. Hosting Our Web Applications
Icon
Introduction
Icon
Compiling our source with Grunt
Icon
Preparing deployments for staging and production
Icon
Deploying our application to Heroku
Icon
Deploying our application to Microsoft Azure
11
11. Scripting for DevOps
Icon
11. Scripting for DevOps
Icon
Introduction
Icon
Executing shell commands with exec
Icon
Executing shell commands with spawn
Icon
Copying, moving, and deleting files and directories
Icon
Archiving files and directories
Icon
Parsing CSV files
Icon
Parsing fixed-width files
Icon
Padding and aligning output
Icon
Formatting dates with moment.js
Icon
Formatting numbers with accounting.js
12
Index
Icon
Index

Working with SQLite

SQLite is a lightweight, schema-based relational database engine that executes within the memory context of our application. This proves to be very convenient when developing your application, as SQLite does not require a database server.

Getting started

We will be using the sqlite3 Node module. You can install this module using NPM as follows:

$ npm install sqlite3

Once installed, you can require it in your application using the following:

sqlite = require 'sqlite3'

Once required, you can create a connection to an existing database by filename:

db = new sqlite3.Database('sample.db')

If the database does not exist, an empty database will be created for you.

We will be using a sample database for our examples, which contains a simple Employees and Departments table. We can see these tables in the following diagram:

Inserting and updating records, and executing commands

Now that we have an empty database, we will create our tables and insert some records.

We will use the Node sqlite3...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Coffeescript Application Development Cookbook
End of Section 6
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon