Relational databases are all about tables. In order to store, organize, or query data; we must first create the tables. In this article, we will use the Data Definition Language (DDL) to learn about the basics of creating tables, choosing data types, adding constraints and default values.
Articles
16 posts
In this video, we will take a look at how to perform some SQL injection attacks on a site, and we’ll learn how to protect our sites from attacks.
Interested in losing an entire afternoon reading about JavaScript? 1. Our journey starts at the hello world page on reactjs.org. But don’t worry, we won’t stay there long, we ended up there by accident looking for the create react app docs. About 1 minute in, we’ll come across the most […]
The WordPress REST API provides us with a way to communicate with our WordPress sites using JSON. To some people, this might not mean much, but to every web and application developer, this is kind of huge. We can use WordPress to easily set up a CMS while taking complete […]
We can use the mysqli functions to access a MySQL database from PHP. mysqli has a Procedural and an Object-Oriented API. This is a quick tutorial on how to perform some basic queries using procedural mysqli. MySQL Improved Extension The general steps that we will follow when performing an SQL […]
When we’re building modern single-page web applications, or when we’re building native mobile and desktop applications, we need an API that accepts and returns data in formats other than HTML. URL encoded data is a common format for sending data to servers, and JSON is common for sending data from […]
JavaScript is one of the most simple yet powerful languages that we can use make apps for pretty much anything. This includes apps for the raspberry pi. In this tutorial, we will learn how to install NodeJs on any raspberry pi. For those of you that would prefer a video, […]
Just some examples of some of the built-in methods you can call on a swift array. Let’s start with some data. A sentence that is split into an array of words. forEach Execute a closure once for each item in an array. map Create a new array based on an […]
net-socket.io is a small wrapper around node's net library, that makes low-level socket programming in JavaScript easy. It is heavily based on Socket.io and Event Emitters.
I introduce IoT and demonstrate using JavaScript to control a Raspberry Pi. This is the recorded video from a lunch and learn event hosted by devhub.ca
A cohort in Calgary was getting upset that I was neglecting them during a lecture, so I made them a present. A hand that connects to slack and waves in front of me every time someone in Calgary has a question. You’re welcome neglected Calgary students.
Problem: Build an advent calendar that automatically unlocks candy each day. Solution: Use razor blades… Obviously!
I’ve been playing around with C code the last couple of weekends. Specifically the libav* libraries from FFmpeg. And it occurred to me that I’ve never made my own C library.
I set up a raspberry pi to emit temperature and humidity data using BLE advertising packets. Then I made an iPhone app that can read that data and display it to me.
