Skip to content
Techno Workshop Logo

all about technology

  • Home
  • Suggest

Category: Databases

Accessing PostgreSQL via SSH Putty tunnel

Learn how to securely access a remote PostgreSQL database through an SSH tunnel using PuTTY on Windows. Step-by-step configuration guide included.

Learn how to securely access a remote PostgreSQL database through an SSH tunnel using PuTTY on Windows. Step-by-step configuration guide included.

Read more →

Author techworkshopPosted on June 12, 2018July 7, 2026Categories Databases

MySQL LONGBLOB: Storing Large Binary Data Properly

Store large files in MySQL with LONGBLOB – BLOB type sizes, the max_allowed_packet fix, insert/stream examples, and when files belong on disk instead.

MySQL LONGBLOB: Storing Large Binary Data Properly

Store large files in MySQL with LONGBLOB – BLOB type sizes, the max_allowed_packet fix, insert/stream examples, and when files belong on disk instead.

Read more →

Author techworkshopPosted on June 11, 2018August 26, 2026Categories Databases, Tools & Tech NewsTags mysql

What Are ORM Frameworks? (Explained with Real Examples)

ORM frameworks explained with real code – how Eloquent, Doctrine, SQLAlchemy and Prisma map objects to tables, their pros and cons, and when raw SQL wins.

What Are ORM Frameworks? (Explained with Real Examples)

ORM frameworks explained with real code – how Eloquent, Doctrine, SQLAlchemy and Prisma map objects to tables, their pros and cons, and when raw SQL wins.

Read more →

Author techworkshopPosted on May 23, 2018September 22, 2026Categories Databases, PHPTags Code Igniter, Laravel

phpMyAdmin Gives 404 on localhost – Here’s the Fix

localhost/phpmyadmin returns 404? Fix the missing Apache include on Ubuntu, XAMPP path issues, and alias configuration – with exact commands.

phpMyAdmin Gives 404 on localhost – Here’s the Fix

localhost/phpmyadmin returns 404? Fix the missing Apache include on Ubuntu, XAMPP path issues, and alias configuration – with exact commands.

Read more →

Author techworkshopPosted on January 31, 2016August 19, 2026Categories Databases, Linux & Servers, Tools & Tech NewsTags ubuntu

Automatically Kill Slow MySQL Queries After N Seconds

Stop runaway MySQL queries automatically – max_execution_time, pt-kill, and an event-scheduler watchdog, with exact commands and safe defaults.

Automatically Kill Slow MySQL Queries After N Seconds

Stop runaway MySQL queries automatically – max_execution_time, pt-kill, and an event-scheduler watchdog, with exact commands and safe defaults.

Read more →

Author techworkshopPosted on January 24, 2016July 17, 2026Categories Databases, Linux & Servers, Tools & Tech NewsTags mysql

Posts pagination

Previous page Page 1 Page 2 Page 3 Next page

Archives

Tag Cloud

  • authentication (3)
  • authorization (2)
  • Code Igniter (5)
  • composer (3)
  • continuous-integration (2)
  • database performance (2)
  • devops (2)
  • dotenv (2)
  • eloquent (3)
  • express (4)
  • filament (7)
  • frontend-development (2)
  • github-actions (4)
  • input validation (2)
  • javascript (4)
  • jest (2)
  • Laravel (49)
  • laravel-admin-panel (3)
  • Laravel Livewire (6)
  • Laravel Livewire Tutorial (3)
  • Laravel Tutorial (4)
  • linux (3)
  • livewire (12)
  • machine-learning (3)
  • mysql (7)
  • nodejs (8)
  • oauth2 (2)
  • package manager (1)
  • passport (2)
  • performance optimization (2)
  • php (28)
  • php-security (2)
  • python (3)
  • react (2)
  • reactjs (2)
  • responsive design (2)
  • security (8)
  • shell (3)
  • tailwindcss (5)
  • ubuntu (11)
  • unix (3)
  • web-development (2)
  • Web Development (7)
  • websocket (2)
  • wordpress (2)

Calendar

September 2026
M T W T F S S
 123456
78910111213
14151617181920
21222324252627
282930  
« Aug    
  • Home
  • Suggest
Proudly powered by WordPress