Showing entries 1 to 10 of 125
10 Older Entries »
Displaying posts with tag: Technical Writing (reset)
OpenLampTech issue #54 – Substack Repost

We have another packed issue of OpenLampTech for you this week. And, we have our first sponsor with a smashing deal to help you configure your MySQL servers with ease. Thank you Releem for partnering with OpenLampTech this week!

The Newsletter for PHP and MySQL Developers

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

In OpenLampTech issue #54, we have content covering:

  • SQL Wildcards
  • PHP Magic Methods Explained
  • Managing CSS in WordPress block themes
  • WordPress as a Twitter alternative?
  • And much much more

[Read more]
The OpenLampTech Developer Newsletter is One Year Old

The OpenLampTech developer newsletter is one year old! I honestly don’t know where the past year went. Obviously, I had my nose buried in some fantastic content since OpenLampTech publishes mostly curated newsletters.

I tell you though, don’t think it isn’t a challenge adding your own thoughts and commentary to someone else’s great content because it definitely is.

I plan to continue publishing curated content in OpenLampTech but, also cover tech reporting and news-related topics that are within the MySQL, PHP, and LAMP stack ecosystems.

There seems to always be plenty to talk about in these areas so a shortage of topics won’t be the issue (I don’t think).

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when …

[Read more]
OpenLampTech issue #52 – Substack Repost

Unbelievably, the OpenLampTech developer newsletter is one year old. Thank you so much for reading and making it possible! I appreciate each and every one of you.

The Newsletter for PHP and MySQL Developers

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

In this week’s OpenLampTech issue #52, we have articles covering:

  • MySQL ordering with NULL
  • 7 WordPress tips for professionals
  • MySQL GUI clients for Linux
  • Working with WordPress custom tables
  • And much much more

Want to support the OpenLampTech

[Read more]
OpenLampTech issue #51 – Substack Repost

This week’s OpenLampTech newsletter has a great mix of round-up posts for you across the PHP and MySQL backend web space. In just 1 more week, we are 1 year old! How nuts is that?!? Enjoy this week’s publication and share with others.

The Newsletter for PHP and MySQL Developers

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

In OpenLampTech issue #51, we are looking at content covering:

  • WordPress keeps the lights on
  • PHP Readonly classes
  • Overview of the LOMP stack
  • Headless Drupal in the CMS space
  • And much much more

A free …

[Read more]
INTERSECT and EXCEPT commands in MySQL

MySQL now supports the INTERSECT and EXCEPT set operators. Set operators work on the results of multiple SELECT statements. In this post, we will see example queries using INTERSECT and EXCEPT commands for a better understanding

The Newsletter for PHP and MySQL Developers

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

While MySQL has supported UNION and UNION ALL commands, there were no INTERSECT or EXCEPT commands in the language. This often involved work-around queries. However, MySQL now does support the INTERCEPT and EXCEPT set operators.

For the example queries, I am using 2 simple tables with arbitrary data.

The names …

[Read more]
OpenLampTech issue #49 – Substack Repost

Writing a weekly newsletter is hard, dedicated work. But, I enjoy reading each week’s edition myself and I hope you do as well. OpenLampTech issue #49 is ready for you. Enjoy this week’s content!

The Newsletter for PHP and MySQL Developers

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

In OpenLampTech issue #49, we have content covering:

  • Laravel Eloquent tips
  • 13 Linux distros from scratch
  • Improve your WordPress site’s performance
  • Most popular databases for PHP
  • And much much more

A free weekly subscription helps support the …

[Read more]
INSERT Using the WITH Clause in MySQL

As of MySQL v8, we have Common Table Expressions (CTEs) or the WITH clause available. I recently learned how to use the WITH clause in an INSERT statement, similar to INSERT with SELECT. Like always, I enjoy sharing what I learn so let’s all learn together…

The Newsletter for PHP and MySQL Developers

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

For the sake of simplicity (and my sanity) I’m using this arbitrary sample data:

SELECT *
FROM auto_test;

We can use the WITH clause to generate

[Read more]
OpenLampTech issue #47 – Substack Repost

Welcome to this week’s OpenLampTech newsletter. I have many great articles curated for you this week. Thank you for reading and please share the publication with others.

The Newsletter for PHP and MySQL Developers

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

In OpenLampTech issue #47, we are looking at articles covering:

  • MySQL Spatial data types
  • Build a blog backend with Laravel
  • 10 Linux command-line operators
  • MySQL row locking
  • And much more

Want to support the OpenLampTech publication? Easy enough.

Head on over to …

[Read more]
OpenLampTech issue #45 – Substack Repost

Once again, OpenLampTech has another full issue for all of your MySQL, PHP, and LAMP stack content. The publication continues to grow. Thank you all for reading.

The Newsletter for PHP and MySQL Developers

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

In OpenLampTech issue #45, enjoy articles covering:

  • Symfony’s Twig
  • MySQL PIVOT functionality
  • Building a niche website with WordPress
  • 10 popular Linux distros
  • And much much more.

Want to know how you can support OpenLampTech?

Head over to the …

[Read more]
Tools of the Trade – Substack Repost

Anyone operating a blog, newsletter, or other creative side hustle knows there are a lot of moving pieces involved behind the scenes. Keeping the cadence going not only requires commitment and skills, but also various tools and software

The Newsletter for PHP and MySQL Developers

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

At the time of writing, the OpenLampTech developer newsletter is entering its 10th straight month of publishing so I thought it was time to share a ‘Tools of the Trade – …

[Read more]
Showing entries 1 to 10 of 125
10 Older Entries »