Substack Repost — OpenLampTech issue #61

2 min readJan 14

--

PHP design patterns | WordPress checklists | MySQL table names case | Harsh realities of using Linux. Thank you so much for reading this repost of the OpenLampTech newsletter!

Receive a free copy of my eBook, “10 MySQL Tips For Everyone”, when you subscribe to the weekly OpenLampTech newsletter.

OpenLampTech has top-level sponsorship opportunities in the weekly newsletter for your brand, product, or service. As a starter publication, collaboration is very budget-friendly. Send a private message for more details and interest.

Joshua Otwell

Written by Joshua Otwell

SQL, PHP, CodeIgniter, and WordPress. Growing through Technical Writing and Blogging. Sign-up for my free developer newsletter here: openlamptech.substack.com

More from Joshua Otwell

SVG of drawn colorful calendar

Joshua Otwell
in
Level Up Coding

How to find the first and last day of a month with Oracle SQL Date Functions

I constantly look to improve SQL-related skills and knowledge. Having a foundational understanding of MySQL, with moderate to heavy use…

5 min readApr 30, 2021

--

Joshua Otwell
in
codeburst

Edit existing FOREIGN KEY constraints in PostgreSQL with the ALTER TABLE command.

While setting up a test database on my system, I discovered the need to ALTER existing FOREIGN KEY‘s. Here’s what I studied, learned, and…

4 min readFeb 28, 2018

--

Joshua Otwell
in
Level Up Coding

Determine the First and Last Day of a Month with MySQL

Working with date values is part of every developer’s job. It seems like we are always looking for or filtering some data by date or a…

4 min readJan 17, 2022

--

Joshua Otwell
in
An Idea (by Ingenious Piece)

Import CSV file data into MySQL table with phpMyAdmin

In the blog post MySQL CREATE TABLE in PHPMyAdmin — with examples, I covered using phpMyAdmin’s visual interface to complete CREATE TABLE…

5 min readApr 29, 2020

--

See all from Joshua Otwell

Recommended from Medium

Love Sharma
in
Dev Genius

System Design Blueprint: The Ultimate Guide

Developing a robust, scalable, and efficient system can be daunting. However, understanding the key concepts and components can make the…

9 min readApr 20

--

Gabe Araujo, M.Sc.
in
Level Up Coding

🧬 How I Used Python to Make Everyday Tasks Easier

Hey there! As a busy person with a lot on my plate, I’m always looking for ways to make my life easier.

8 min readMay 1

--

Lists

Stories to Help You Grow as a Software Developer

19 stories70 saves

Leadership

30 stories29 saves

How to Run More Meaningful 1:1 Meetings

11 stories35 saves

Stories to Help You Level-Up at Work

19 stories53 saves

Tate Galbraith
in
Better Programming

6 More Unique Linux Utilities You Forgot About

To the depths of /usr/bin once more

5 min readDec 1, 2022

--

The PyCoach
in
Artificial Corner

You’re Using ChatGPT Wrong! Here’s How to Be Ahead of 99% of ChatGPT Users

Master ChatGPT by learning prompt engineering.

7 min readMar 17

--

Bobby
in
Level Up Coding

6 Pythonic Ways to Replace if-else Statements

Avoid if-else the Pythonic Ways

6 min readFeb 27

--

Alexander Nguyen
in
Level Up Coding

Why I Keep Failing Candidates During Google Interviews…

They don’t meet the bar.

4 min readApr 13

--

See more recommendations

Help
Status
Writers
Blog
Careers
Privacy
Terms
About
Text to speech