Support Ukraine
Russia's war against Ukraine is real and raw.
Civilians are getting killed, families destroyed, homes wrecked.
Our hearts are with those who suffer.

(267) 429-4900

  • Facebook
  • Twitter
  • LinkedIn
  • GitHub
  • Stack Overflow
  • Overview
  • Works
  • Projects
  • Articles
  • Contacts

Database Administration

How to split and search in comma-separated string in MySQL

May 3, 2017May 23, 2018 Michael Ryvkin Database Administration 25 Comments 64

There could be times when you need to split comma-separated values in a string and get a value at certain position. Obviously this could be done with explode in PHP or split in Perl using server-side script but what if you need to do it directly in MySQL.

Read More

PostgreSQL crashes when using pgcrypto functions

October 22, 2009May 7, 2017 Michael Ryvkin Database Administration

After upgrading PostgreSQL from 7.4 to 8.2 it started crashing sporadically with the following entries in the log file:

LOG:  server process (pid 21460) was terminated by signal 11
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing shared memory and semaphores
Never Miss an Article!
Join other developers and get our latest posts by email.

GO
Gyrocode LLC is a web development agency located in scenic Bucks County, PA. We offer website design and web development services for small and medium-sized businesses.

Connect

  • Facebook
  • Twitter
  • LinkedIn
  • GitHub
  • Stack Overflow

Contact

(267) 429-4900

Call on Skype

Links

  • Privacy Policy
© Gyrocode LLC. All rights reserved.
Never Miss an Article!
Join other developers and get our latest posts by email.

GO
close-link