Tagged Questions
MySQL is an open-source, relational database management system.
14
votes
9answers
322 views
+100
jQuery post request interrupted: Only half of post parameters arrive
I have a noticed a strange phenomenon in my LAMP environment.
Over the frontend I execute an AJAX post request with jQuery like this:
$.post('save.php', {data1: d1, data2: d2, [...], dataN: dN})
...
5
votes
0answers
151 views
+50
Accessing VARCHAR as BINARY during read with Entity Framework and MySQL?
The base of the problem:
Pun intended.
The problem starts with a very old dBase database where the textual information is encoded directly into DOS Cyrillic (CP-866), and because that's not enough ...
5
votes
4answers
168 views
+500
Unable to select Database Foo using Ec2 and RDS
I have set up an RDS Database Instance with a security group where I use my EC2 Elastic IP as my CIDR/IP. I have also associated the security group with my EC2.
My security group on the EC2 ...
6
votes
6answers
140 views
+50
Average of latest N records per group
My current application calculates a point average based on all records for each user:
SELECT `user_id`, AVG(`points`) AS pts
FROM `players`
WHERE `points` != 0
GROUP BY `user_id`
The business ...
0
votes
1answer
66 views
+100
ASP.NET MVC: Save multiple values on autocomplete
I have a mysql database with the tables "deliverables", "tags" and "deliverables_has_tags". I want to link tags to a deliverable.
This is what I do in my javascript file:
<script ...
3
votes
2answers
42 views
+50
Rails + MySQL + Transactions + Locking, how do I prevent opening a transaction from unlocking the table?
In my Rails code I need to confirm that an action is allowed only if there is more than 1 of a certain record remaining. For this reason I need to lock updates and then perform a read. My rails code ...
1
vote
0answers
69 views
+50
How to expose a MySQL database as OData
I currently have a mySQL database and want interact with it using OData.
In other words, I want to expose the data in this form:
http://services.odata.org/Northwind/Northwind.svc/
I've found several ...
2
votes
1answer
87 views
+50
MySQL Full text search extremely slow on a AWS RDS large instance
I have a table having 14 million rows and i am trying to perform a full text search on this table. The query for this is performing really slow, it is taking around 9 seconds for a simple binary AND ...
1
vote
2answers
86 views
+200
Handling two almost identical tables as one model
I'm working on creating some models for the wikimedia databases located on wikimedia labs, and due to technical issues, there are two tables for revisions.
One table revision contains all revisions, ...
3
votes
6answers
217 views
+200
SQL Random rows in a big table (with where clause)
I have a website where people can vote on cars. 4 cars are showed to the user and he/she can vote on the car they like most.
The table cars has the important columns:
car_id int(10) (not ...
1
vote
0answers
39 views
+100
Using the minus sign on multiple-words in full text boolean mode
I am just doing a bunch of testing with mysql's full text boolean mode and from my testing it doesn't seem you can use the minus sign on multiple words?
I have two rows for example..
id,name
...
1
vote
1answer
73 views
+100
Storing changes on entities: Is MySQL the proper solution?
i want to store changes that i do on my "entity" table. This should be like a log. Currently it is implemented with this table in MySQL:
CREATE TABLE `entitychange` (
`id` int(11) unsigned NOT NULL ...
