Author: admin
-
CREATE Table
SQLite CREATE TABLE statement is used to create a new table in any of the given database. Creating a basic table involves naming the table and defining its columns and each column’s data type. Syntax Following is the basic syntax of CREATE TABLE statement.CREATE TABLE database_name.table_name( column1 datatype PRIMARY KEY(one or more columns), column2 datatype, column3 datatype,…
-
DETACH Database
SQLite DETACH DATABASE statement is used to detach and dissociate a named database from a database connection which was previously attached using ATTACH statement. If the same database file has been attached with multiple aliases, then DETACH command will disconnect only the given name and rest of the attachment will still continue. You cannot detach the main or temp databases. If…
-
ATTACH Database
Consider a case when you have multiple databases available and you want to use any one of them at a time. SQLite ATTACH DATABASE statement is used to select a particular database, and after this command, all SQLite statements will be executed under the attached database. Syntax Following is the basic syntax of SQLite ATTACH DATABASE statement.…
-
CREATE Database
In SQLite, sqlite3 command is used to create a new SQLite database. You do not need to have any special privilege to create a database. Syntax Following is the basic syntax of sqlite3 command to create a database: − Always, database name should be unique within the RDBMS. Example If you want to create a new database…
-
Data Type
SQLite data type is an attribute that specifies the type of data of any object. Each column, variable and expression has related data type in SQLite. You would use these data types while creating your tables. SQLite uses a more general dynamic type system. In SQLite, the datatype of a value is associated with the…
-
Installatino
SQLite is famous for its great feature zero-configuration, which means no complex setup or administration is needed. This chapter will take you through the process of setting up SQLite on Windows, Linux and Mac OS X. Install SQLite on Windows Install SQLite on Linux Today, almost all the flavours of Linux OS are being shipped…
-
Overview
This chapter helps you understand what is SQLite, how it differs from SQL, why it is needed and the way in which it handles the applications Database. SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is one of the fastest-growing database engines around, but that’s growth in…
-
Conclusion
With that, we have covered the basics of building a REST API. In this post, we used Node.js and Express to build some simple endpoints that can be expanded. Overall, the above code gives a good place to start when building out APIs for your applications. Once you’ve built your APIs, you’ll likely want to…
-
Adding in API Analytics and Monetization
Building an API is only the start. Once your API endpoint is created, you’ll want to ensure that you monitor and analyze incoming traffic in addition to your API testing tool. Doing this lets you identify potential issues and security flaws and determine how your API design is used. These can all be crucial aspects…
-
How to Build a REST API
Now that we’ve reviewed all of the basics of what a REST API is and other fundamentals, it’s time to build one out. The example below shows a straightforward example of how to implement a REST API with NodeJS and Express. No actual CRUD operations are being done within the endpoints, but you can use…