© 2022 Hashnode
#sql
Javascript has seen a huge growth in usage and functionality, from being a scripting language used for websites, to server-side programming, and much more. NodeJS, or Node for short, is a runtime envi…
In my last post on Object-Relational Mapping (ORM), I open up by placing emphasis on the importance of adequate data management. I know there is a concept in programming called DRY (Don't Repeat Yours…
NULL Value A field that has a null value, is a field which does not have any value. This actually means that field will be kept blank, it will not have any sort of 0’s or spaces. Test for Null Value…
This post was motivated after a migration to TimescaleDB to support higher ingest rates for our event stores, logs, and journals. We normally avoid and set constraints to prevent updates to hypertable…
Table variable syntax:declare @my_table_variable table( id int, name varchar(50) ); select * from @my_table_variable; go Table variable is a local variable with a special data type table. Table variable is not created in memory. It is cr…
This statement is used for insertion of new records in the table. The syntax of the insert into statement INSERT INTO table_name (col1,col2,..) VALUES(val1,val2,...); The insert into statement can …
What is Database? A database is a systematic and organized collection of data. Data can be text, videos, files, audio and so on. It is used to arrange the data in a proper way so that sorting, searchi…
Both MySQL and PostgreSQL are open-source, relational database management systems (or databases, for short). They’re commonly used for storing data in web applications, but they can also be used for o…
One of the primary issues in the database world is SQL injection – it’s prevalent to such an extent that even OWASP continuously lists it as the #1 threat targeting web applications. SQL injection can…
prerequisites: 1) WAMPSERVER 2) Eclipse/Apache NetBeans IDE The Java Database Connectivity (JDBC) API: Java Database Connectivity (JDBC) is an application programming interface (API) which defines ho…