Items tagged mysql in 2012
Filters: Year: 2012 × mysql × Sorted by date
How can I detect manual record insert from mysql cansole into my code in django .?
You can’t. The best you can do is have Django periodically poll MySQL to see if anything has changed (maybe with a custom management command run by cron)—having a TIMESTAMP field on every table which will be automatically set to the current time when a record is inserted will help you spot things that have changed.
[... 80 words]What tools and techniques are used for relational database version control (structure and data)?
The term you are looking for is database migrations (sometimes called database change scripts).
[... 308 words]Any source available to download sample data (in 10+ GB) for testing?
Wikipedia has some pretty interesting dumps, in both XML and SQL format: http://meta.wikimedia.org/wiki/I...
[... 100 words]What is the most efficient way to lookup an object (e.g. a user) by only a string?
Yes—an index on a varchar column is exactly how you would implement this.
[... 38 words]Python Django load MySQL database from csv files performance issue?
Don’t use the Django ORM for bulk imports—the performance overhead is pretty small for regular web page stuff, but it adds up if you are running millions of inserts.
[... 63 words]How can you build a search engine for a website built in PHP/MySQL?
There are a bunch of options.
[... 310 words]What are XML feed best practices?
It sounds like you’re pretty much screwed already, if you’re dealing with companies that still think FTPing XML around is a sensible thing to do.
[... 364 words]Has anyone implemented a message queue with mysql and many workers?
Flickr built their own message queue on top of MySQL: http://code.flickr.com/blog/2008...
[... 29 words]