Ruby, MySQL: Connection pool that is outside of the rails framework?
Is there a ruby gem or such for MySQL connection pooling that isn't part of rails? I simply have a ruby script (again, I don't do anything with rails). ...
mysql
Matching First Alphanumeric Character skipping (The |An? )
I have a list of artists, albums and tracks that I want to sort using the first letter of their respective name. The issue arrives when I want to ignore "The ", "A ", "An " and other various non-alphanumeric characters (Talking to you "Weird Al" Yankovic and [dialog]). Django has a nice start '^(An?|The) +' but I want to ignore those a...
How to analyse Wikipedia article's data base with R?
Hi all, This is a "big" question, that I don't know how to start, so I hope some of you can give me a direction. And if this is not a "good" question, I will close the thread with an apology. I wish to go through the database of Wikipedia (let's say the English one), and do statistics. For example, I am interested in how many active ...
MySQL Gurus: How to pull a complex grid of data from MySQL database with one query?
Hopefully this is less complex than I think. I have one table of companies, and another table of jobs, and a third table with that contains a single entry for each employee in each job from each company. NOTE: Some companies won't have employees in some jobs, and some companies will have more than one employee in some jobs. The company...
how to use SMTP + PHP + MYSQL ?
I've got a mass mail function that sends e-mail to all email addresses in my mysql table, but they all get received marked as spam. I want to use smtp validate to fix this. How can I use smtp validation with mail($email, $subject, $message, $headers);? ...
MongoDB - proper use of collections?
In Mongo my understanding is that you can have databases and collections. I'm working on a social-type app that will have blogs and comments (among other things) and had previously be using MySQL and pretty heavy partitioning in an attempt to limit possible concurrency issues. With MySQL I've stuffed all my user data into a _user databa...
MySQL One to Many order by number found in joined table
Two tables: table_a ------- table_a_id: (primary, int) table_b ------- table_a_id: (index, int, from table_a) table_b_value: (varchar) A one to many relationship between table_a_id and table_b_value. Given a query like this: SELECT DISTINCT(table_a_id) FROM table_a JOIN table_b ON table_a.table_a_id=table_b.table_a_id I want to ...
Parsing timestamps - do it in MySQL or in PHP?
Let's say you've got a table with a timestamp column, and you want to parse that column into two arrays - $date and $time. Do you, personally: a) query like this DATE(timestamp), TIME(timestamp) , or perhaps even going as far as HOUR(timestamp), MINUTE(timestamp b) grab the timestamp column and parse it out as needed with a loop in PH...
MySQL - two counts with different WHERE in one query
table field1 field2 a 1 b c 3 e 4 f I need to count field1 and not empty field2 with on query: SELECT COUNT(field1) FROM table + SELECT COUNT(field2) FROM table WHERE field2 != '' result should be 5 and 3 in one query. Is it possible? ...
UTF-8 Database Problem
I've a MySQL table that has a UTF-8 charset and upon attempting to insert to it via a PHP form, the database gives the following error: PDOStatement::execute(): SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xE8' for column ... The character in question is 'è', yet I don't see why this should be a problem cons...
Need to capture and store receiver's details via IPN by using Paypal Mass Pay API
Hi all, This is a question about Paypal Mass Pay IPN. My platform is PHP & mySQL. All over the Paypal support website, I have found IPN for only payments made. I need an IPN on similar lines for Mass Pay but could not find it. Also tried experimenting with already existing Mass Pay NVP code, but that did not work either. What I am tr...
SQL order by oldest from Unix Timestamps
Hello. How do I use SQL to order results by oldest first? I am using unix timestamps. Thanks. ...
MySQL - biggest value from two fields
I need to get the biggest value from two fields: SELECT MAX(field1), MAX(field2) Now, how can I get biggest value from these two? ...
Need an alternative to two left joins.
Hey guys quick question, I always use left join, but when I left join twice I always get funny results, usually duplicates. I am currently working on a query that Left Joins twice to retrieve the necessary information needed but I was wondering if it were possible to build another select statement in so then I do not need two left joins ...
ImportError: No module named MySQLdb in Zope
I can import MySQLdb from the interactive python command line but Zope gives me an import error when I try it from within a script (python) in Zope. Could Zope be not looking in the same places as the command line for some reason? ...
Explain this SQL query in plain English.
Please explain, in plain English, what question this SQL query answers: SELECT SUM(price) FROM Room r, Hotel h WHERE r.hotelNo = h.hotelNo and hotelName = 'Paris Hilton' and roomNo NOT IN (SELECT roomNo FROM Booking b, Hotel h WHERE (dateFrom <= CURRENT_DATE AND dateTo >= CURRENT_DATE) AND b.hotelNo = h.hotelNo AND hotelName = 'Paris ...
How do I get the median/mode/range of a column in SQL using Java?
I have to get the median, mode and range of test scores from one column in a table but I am unsure how to go about doing that. When you connect to the database using java, you are normally returned a ResultSet that you can make a table or something out of but how do you get particular numbers or digits? Is there an SQL command to get the...
Rails Unit Testing with MyISAM Tables
I've got an application that requires the use of MyISAM on a few tables, but the rest are the traditional InnoDB type. The application itself is not concerned with transactions where it applies to these records, but performance is a concern. The Rails testing environment assumes the engine used is transactional, though, so when the test...
MySQL get list of unique items in a SET
I have a products table with a column of type SET (called especialidad), with these possible values. [0] => NADA [1] => Freestyle / BMX [2] => Street / Dirt [3] => XC / Rural Bike [4] => All Mountain [5] => Freeride / Downhill / Dual / 4x [6] => Ruta / Triathlon / Pista [7] => Comfort / City / Paseo [8] => Kids [9] => Playera / Chopper...
Inbox Functionality with MYSQL
So I am writing a simple inbox private message system. My table schema is as follows: messageID message sender id receiver id date sent read ( 0 = no , 1 = yes) I am able to show the messages for the user by relating his userID to receiverID. However I also want to show the messages he has sent in the inbox to the user. For exampl...