Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 16

Displaying posts with tag: django (reset)

How the MariaDB download system works
+2 Vote Up -0Vote Down

During my years at MySQL AB I had the unfortunate task of manually maintaining the download page for enterprise customers. This involved a ton of boring, error prone work and almost always led to some sort of error every release. Some of our downloads were eventually replaced with an automated system written by the web team but the memory of all that time wasted still hurts me. So when I joined Monty Program and saw our downloads were manually maintained in mediawiki I knew something had to change.

Most of the websites for Monty Program and the MariaDB project are written with Django so this is where I started. I used our existing website code base and just created a new django application for downloads.  There are many models / tables involved in the system but the important ones are:

  • Releases: A list of all the
  [Read more...]
Tech Messages | 2010-04-24
+0 Vote Up -0Vote Down

A special extended edition of Tech Messages for 2010-04-15 through 2010-04-24:

  [Read more...]
News from the Web Stack: Update Center install and Django
Employee_Team +0 Vote Up -0Vote Down

Jeff's blog entry on installing Web Stack using IPS (a new feature in 1.5) now has a screencast version (4 min. ogg format, use Firefox 3.5 or VLC 1.0), courtesy of Brian. The GlassFish Web Stack (see recent 1.5 release) uses the same packaging technology as the GlassFish App Server and as OpenSolaris (where the technology initially came from).

IPS, also known as pkg(5), offers a packaging system and tools (both

  [Read more...]
Freiwild almost ready for Django 1.0.2
Employee +0 Vote Up -0Vote Down
I've been working on our Freiwild Shop website today making it compatible with Django 1.0.2 (final(ly)!). Basically, what I've done is try to run it and fix where it errors following the direction documented in the manual. I think that the next days I'll see how I can optimize the MySQL usage a bit.

The shop I've build has little models and doesn't use to much fancy tricks. Among the changes:
  • Templates: extends should be on the first line

  • Models: should not contain anything Admin-related. This is actually very nice, seperating models.py and admin.py.

  • Model Fields: maxlength changed to max_length, oldforms/newforms options disappeared, small stuff like

  [Read more...]
MySQL vs Postgres, Again - Is Postgres Better?
+0 Vote Up -0Vote Down

I was browsing the web on this lazy Sunday afternoon and ran across a good article on the Rarest Words blog. The author was trying to get Django installed and running with Postgres. From the author's own admissions, he is not a Postgres fanatic.

Well, this and last year I hear everywhere that PostgreSQL is the way to go and that usage of mySQL in 2008 makes people puke… But without any real arguments (besides "Postgres is the way to go").

After some not so compatible errors with these not so compatible databases, the author did get it working and ran some benchmarks. Postgres did not turn out faster than MySQL. If you ask anyone in the Postgres community

  [Read more...]
Google's Appengine - some initial thoughts
+0 Vote Up -0Vote Down

Google has just announced their alternative to Amazon’s s3 called ‘App Engine’. 

I think that if this is successful it will provide a shift in some of the basic web development economics and practices, even more than Amazon’s s3 has.

- Small hosting providers (ones that offer a shell account for $12/month) will be marginalized. why pay for something when you get it for free?

- M&A. It will create a 3rd platform to develop on. you currently have LAMP and Windows. The google app engine provides a 3rd. The major difference is you can’t buy it. If we acquire a company who runs on this platform we have 2 choices. continue paying google for the infrastructure, or redevelop it onto LAMP. of course

  [Read more...]
Symfony + MySQL to Django + PostgreSQL
+0 Vote Up -0Vote Down

While recently migrating Tschitschereengreen.com from Symfony to Django plus changing the database backend from MySQL (http://www.mysql.com/) to PostgreSQL, there were mainly two tasks more time-consuming than I’ve had thought beforehand:

SQL dump

The old database used a latin1 encoding for the database fields and utf-8 as the server and client connection encoding. With these settings, even trying to get a correctly encoded database dump from phpMyAdmin is a bad idea.

Using mysqldump with an explicitly specified character-set is much better:

mysqldump ? ?default-character-set=latin1 ?skip-set-charset dbname >
  [Read more...]
work @ webfaction: they need an australian customer support person
+0 Vote Up -0Vote Down

What they need the most in the short term is someone who could do customer support between 3am and 11am, London time, so someone in Australia would be perfect

Do you happen to know anyone who might be interested in the job?

Ideally it would be someone who’s familiar with web technologies (web, DNS, e-mail servers), linux and maybe some web frameworks (Django, Rails,. ..).

The candidate would be doing customer support (answering tickets) but if they’re interested they could also do sysadmin work or even development work.



see the webfaction job page for more details

Google Test Automation Conference 2007
+0 Vote Up -0Vote Down

The titles of the videos look very much like “must watch”. Found via ThinkPHP, thanks.

Django and UTF8
+0 Vote Up -0Vote Down

I have to deal with it now and a lot of other people too, judging by the utf8/unicode/encoding topics on the django mailing list. I have found this one thread quite interesting and looks like the problem solver, but may be I also just need to learn a bit more about the bits and pieces that make this whole thing work. This message obviously tells how to make mysql completely aware and well-handling utf8.
Next thing on the list the django setting parameter DEFAULT_CHARSET.

Convert MySQL table to utf8
+0 Vote Up -0Vote Down

Read here how to change all your DB to utf8, pretty simple, but you gotta know it. Even when your app runs in latin1 only, it reduces a couple problems in case you forgot some check and utf8 is slipping through. I will let you know if I can prove that right. But since Django is trying to be unicode compliant, it’s easier to use it than to work around it.
It does at least already eliminate the problem of getting this error:

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)

this was discussed here.
In short:


Multithreading with MySQLdb and weakrefs
+0 Vote Up -0Vote Down

I was fighting four days now, with a threading problem, which are known to be hard to track. But I finally found it and learned that I actually had made a beginner’s mistake.

What happened?
From the front end I trigger via AJAX a view that again starts a thread that does some import work, that might take quite a while. This enables the user to keep going and have the import run without interrupting him/her. Every once in a while an asynchronous call checks on the state of the import.
And here lies the problem: while the thread is running and busy like a bee adding data in the DB the asynchronous call to check on the state also tries to run a query and that causes the following exception:

 File "/Users/cain/programming/django/trunk/django/db/backends/mysql/base.py",
line 42, in execute

  [Read more...]
Integration news x 2
+0 Vote Up -0Vote Down

Brian Aker starts work on a memcache engine for mysql. so your memcache cache acts just like a table.

the big thing here which I’ve seen asked for a couple of times on the memcached list is the ability to see a list of keys.

mysql > select * from foo1 WHERE k=”mine”;

freaking amazing.. I love these kind of mashups.

and the 2nd important event.

Django is starting a branch to integrate SQLAlchemy

memcached performance
+0 Vote Up -0Vote Down

two interesting posts arrived on the memcached list which might be interesting to performance people.

The first was a comparison of The fastest lanugage binding on which ‘P’ language performed better. To make a note the PHP version actually uses libmemcache a ‘C’ library which goes a bit of the way to explain the wild disparity in speeds.

The 2nd more interesting one (to me) was the discussion of how Digg switched from using mysql to memcached with v3 of their new interface to handle storing sessions, due to a hardware crash on their mysql server.

others mentioned using InnoDB for this instead of MyISAM,

  [Read more...]
6 degrees of seperation
+0 Vote Up -0Vote Down

are you a committer or a member of a large OSS project?

do you participate in any other large open source project?

I’m trying to get a understanding of how all the different major oss projects are being cross pollinated by having people participating in different projects.

feel free to comment, or mail me directly at ian at holsman.net


django - signals
+0 Vote Up -0Vote Down

continuing the recent thread about contenttypes in django I thought I would talk about a feature which got added in the magic removal branch, which doesn’t have as much attention as I think it deserves.

signals and the dispatcher.

signals are way of telling the rest of the world that something happened. If you are interested you simply listen for it (connect in django speak).

take for example my tagging application currently in use on zyons. one of it’s features is that it let’s users store their own tags.

One of the performance improvements I added to this was the creation of a ‘summary’ tag which

  [Read more...]
Showing entries 1 to 16

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.