infovore + mysql   19

Best practice: Import mySQL file in PHP; split queries - Stack Overflow
"Here is a memory-friendly function that should be able to split a big file in individual queries without needing to open the whole file at once:" Yep, that'll do.
php  mysql  data  import  utility  script 
april 2011 by infovore
Useful temporal functions & queries |
"Here’s a complication of some common and useful time & date calculations and equations. Some, though very simple, are often misunderstood, leading to inefficient or incorrect implementations. There are many ways to solve such problems. I’ll present my favorites." These are, indeed, useful, and I've been using a few of them recently.
mysql  tips  programming  databases  sql 
december 2009 by infovore
Riding Rails: Upgrading to Snow Leopard
A good list of tips - lots of compiled stuff needs to be recompiled to x64, and this will be confusing. I am not upgrading quite yet.
ruby  rails  mac  osx  mysql  snowleopard  upgrade  tips 
august 2009 by infovore
SQL pie chart |
"My other half says I’m losing it. But I think that as an enthusiast kernel developer she doesn’t have the right to criticize people." Generating ASCII pie charts with a single SQL query. It's a very, very big query. It's a bit crazy.
sql  mysql  ascii  graphics  programming  visualization  sick 
august 2009 by infovore
qwantz: "select" is a workhorse, "update" is as routine as a pair of pants. "coalesce" is something special
Ryan North makes a little poem dedicated to the COALESCE function in MySQL. He's right: it's super useful.
databases  mysql  poem  ryannorth  poetry  programming  sql  coalesce 
june 2009 by infovore » Blog Archive » cakephp on os x can’t connect to mysql
The reason CakePHP has issues connecting to MySQL database on OSX 10.5 is because its database adaptor is explicitly looking for the default mysql socket defined in your php.ini. If you fix that, everything works. The critical adjective, if you ever search for this again, is the "OSX" part.
osx  development  mysql  cakephp  troubleshooting  frustrating 
february 2009 by infovore
Sequel Pro – MySQL database management app for Mac OS X
"Sequel Pro is the perfect tool for working with database-driven websites and applications." Leopard-only MySQL management application; forked out of the long-neglected CocoaMySQL.
leopard  macosx  web  database  mysql  utility  application 
august 2008 by infovore
"Are you tired of browser-based games that are thinly veiled interfaces for databases? Finally, there's a game that just is a database!" This looks awesome.
mysql  games  database  programming 
august 2008 by infovore
MCslp Coalface » MySQL and DBD::mysql on Mac OS X
"The problem exists only with binary distributions of MySQL and is related to the installation location of the libraries for the MySQL client that DBD::mysql uses." Ran into this problem today; wasted an hour on it. Never again.
mysql  perl  cpan  mysqldbd 
february 2008 by infovore
Getting the mysql gem installed on Ubuntu at brant interactive
"The problem is that you need the MySQL development headers in order to get the ruby gem to compile…sooo, you need to install this first."
ubuntu  ruby  rails  mysql 
december 2007 by infovore
g30rg3 Blog » UTF-8 Database Converter
A useful plugin for Wordpress - prior to 2.2, data was stored as latin1. Now it's UTF-8. If you've got a lot to convert, this seemed to do the trick.
wordpress  plugins  encoding  utf8  databse  mysql 
september 2007 by infovore
How to find the max row per group in SQL without subqueries - Xaprb
As with so many other SQL challenges, if you re-phrase the question, it’s easy to select the maximum or minimum row per group without subqueries. The key is to understand what you want, and to be able to word the problem in a way that translates from En
sql  mysql  database  programming  performance  howto 
may 2007 by infovore
MySQL Performance Blog
Ooh, crunch - nitty, gritty, technical (and often above-my-head) blog devoted to MySQL performance. But lots of good data in here nontheless. Mmn.
mysql  database  blog 
may 2006 by infovore
tim's journal: ODBC MySQL Mail Merge
The bug Darryl Miles points out is the important thing to note, and a real show-stopper. Handy to be able to do this, though
mysql  office  word  merge  odbc 
february 2006 by infovore
MySQLfor Other Applications
Some useful reminders in here, even if most of it's been covered before
mysql  howto  guide  webdev 
july 2005 by infovore : Freetag - an Open Source Tagging / Folksonomy module for PHP/MySQL applications
"Freetag is an easy tagging and folksonomy-enabled plugin for use with MySQL-PHP applications"
php  mysql  webdev  folksonomy  tagging  tags 
april 2005 by infovore

Copy this bookmark: