Joshua Otwell
codeburst.io
Ruston, LA, United States
Contact Joshua
Discover and connect with journalists and influencers around the world, save time on email research, monitor the news, and more.
| Recent: |
|
| Past: |
|
Past articles by Joshua:
Exploring MySQL Constraints: NOT NULL — With examples.
Many times, we nonchalantly slap the NOT NULL constraint on our database columns during table creation. But what is NOT NULL? And more importantly, what is it used for? We are going to learn… → Read More
FOREIGN KEY Referential Actions in MySQL — with examples.
In FOREIGN KEYS in MySQL with examples. I discussed establishing referential integrity between multiple tables sharing related and associated data using a FOREIGN KEY. However, the included syntax… → Read More
MySQL SELECT INTO Syntax Part 1 — Uses With Variables.
This blog post will cover examples of MySQL SELECT INTO syntax for storing column values in variables. → Read More
The LIMIT clause — Examples with MySQL. – codeburst
Don’t want all records returned in the query results? Maybe you need pagination for a results set or web app… Many of these requirements can be taken of by applying the LIMIT clause to your query… → Read More
Code snippet syntax highlighting in Gutenberg via shortcodes — Continued learning…
With Gutenberg coming full-on to WordPress core soon, I’ve committed to try to learn all I can about it. → Read More
Convert existing HTML to Gutenberg block — With examples
In this blog post, I’ll take exisitng HTML, consisting of a heading and 2 paragraphs, and convert them to a Gutenberg Block. → Read More
PostgreSQL TRIGGERS and \copy working in tandem. – codeburst
After coming off of an injury-ridden June, July turned out to be a more promising (except the sweltering Louisiana heat) month with me getting in plenty of solid hikes as I try to stay active and… → Read More
Getting a handle on Gutenberg… slowly. – codeburst
With blogging, I am always on the search for ways to make the whole process easier and more proficient. One thing I discovered long ago, the WordPress default editor leaves a lot to be desired. In my… → Read More
A loosing battle with a DEFAULT column value… Lessons learned.
While learning through a video tutorial on creating Form and Login Systems with PHP and MySQL, I ran into a minor issue, that I would like to share in this blog post and what I did to solve it… → Read More
Sublime Text and Sed for a winning combo on HTML tags.
I’m writing this short blog post to share with you a couple of different ways I manipulate multiple HTML tags I need to target for various reasons. Sublime Text is a fantastic editor but there is… → Read More
PostgreSQL Subquery as predicate in WHERE clause. – codeburst
In Exploring subqueries in PostgreSQL — Column names and expressions, I discussed generating SELECT statement columns and expressions with subqueries. This blog post will visit another common… → Read More
Digging into PLpgSQL — Scratching the surface with easy functions.
I’m quite intrigued when it comes to PostgreSQL’s procedural language, PLpgSQL (honestly, SQL stored procedures and functions in general). I’ve grown fond of writing functions on the ‘server-side’… → Read More
Utilize parameters with MySQL Stored Procedure by examples.
MySQL Stored Procedures and Functions enable database devs the ability to wrap useful bits of code in a nice little ‘package’ for reuse. → Read More
Hacking SQL — Tools, Utilities, and Work flow. – codeburst
I recently got a great suggestion from a reader over on Medium about sharing my workflow tools when hacking on SQL (mainly PostgreSQL, but sometimes MySQL also), hence here we are in this blog post… → Read More
Database command categories: A high level overview — DDL.
This blog post is part 1 in a ‘mini-series’ of posts providing a high-level overview of SQL database commands. Coverage here is not exhaustive, only a brief visit of the command category. I’ve also… → Read More
Use shortcuts in psql to make your life easier with the \set meta-command.
Everyone likes a shortcut. So long as it doesn’t backfire. Cutting corners and some shortcuts are a bad idea. But I’m talking about a handy, productive shortcut. Now those I can really dig. Keep… → Read More
Exploring subqueries in PostgreSQL — Column names and expressions.
There is an old saying that there is more than one way to skin a cat. Fear not, I won’t be skinning any, but that saying applies for many queries within PostgreSQL (and SQL in general). While the… → Read More
PostgreSQL CREATE TABLE AS with examples. – codeburst
I need to export this data to a file, make a new table, then import that data into the new table… Boring. Let’s use CREATE TABLE AS syntax in PostgreSQL to easily knock out tasks like this. Note: All… → Read More
ON vs USING: Nuances between clauses with LEFT JOIN’s — An observation.
I love learning and sharing interesting things as I continue to forge SQL database developer skills. Both the ON and USING clauses are similar when ployed with JOIN‘s. But I think they are far from… → Read More
What’s missing? Find out using OUTER JOIN’s in MySQL with examples.
What’s missing? What matches in one table but not another? MySQL (and SQL in general) have a way to find out. More than likely, when working with a normalized database, you are faced with these types… → Read More