WaSQL Wired

WaSQL Wired

Get beyond the basics of programming with in-depth dives into databases, SQL, PHP, Python, JavaScript, CSS, HTML, WaSQL, and more.

Featured Posts

JavaScriptJavaScript
JavaScript Crash Course

JavaScript Crash Course

What you need to know to become a JavaScript guru.

Steven Lloyd
Steven Lloyd
LuaLua
Mastering Lua

Mastering Lua

A Comprehensive Guide to Coding in Lua

Steven Lloyd
Steven Lloyd
GitGit
Command Line Git

Command Line Git

From basic to advanced, this will help you become a Git Pro

Steven Lloyd
Steven Lloyd

Archive

GitGit
Command Line Git

Command Line Git

From basic to advanced, this will help you become a Git Pro

Steven Lloyd
Steven Lloyd
LuaLua
Mastering Lua

Mastering Lua

A Comprehensive Guide to Coding in Lua

Steven Lloyd
Steven Lloyd
JavaScriptJavaScript
JavaScript Crash Course

JavaScript Crash Course

What you need to know to become a JavaScript guru.

Steven Lloyd
Steven Lloyd
DatabasesDatabases
Querying Databases with Python

Querying Databases with Python

SQLite, MySQL, MSSQL, PostgreSQL, Oracle, SAP HANA, Snowflake, MS Access, Firebird

Steven Lloyd
Steven Lloyd
PHPPHP
PHP 8 Crash Course

PHP 8 Crash Course

What you need to know to become a PHP guru.

Steven Lloyd
Steven Lloyd
DatabasesDatabases
+1+1
Describe table in PostgreSQL? Yes we can.

Describe table in PostgreSQL? Yes we can.

Build a custom Describe Table function in postgres using File FDW

Steven Lloyd
Steven Lloyd
RegexRegex
Regular Expressions Made Simple

Regular Expressions Made Simple

A simple guide to understanding and using regular expressions

Steven Lloyd
Steven Lloyd
PythonPython
Python Crash Course

Python Crash Course

What you need to know to become a python guru.

Steven Lloyd
Steven Lloyd
PostgresqlPostgresql
Put your tables to REST with Postgres File DFWs

Put your tables to REST with Postgres File DFWs

Read REST services as a local table using PostgreSQL

Steven Lloyd
Steven Lloyd
DatabasesDatabases
+2+2
JSON Recordsets are Your Friends

JSON Recordsets are Your Friends

Regardless of what database you use, you can probably harness JSON recordsets to improve your queries.

Steven Lloyd
Steven Lloyd
DatabasesDatabases
+1+1
File Foreign Data Wrappers

File Foreign Data Wrappers

Harnessing the power of Postgres File FDW to access system info

Steven Lloyd
Steven Lloyd