Yesterday, I tried a hint from Seb for reanimating the old yoosic system by accessing the db directly from Django. The problem was that it is an MyISAM-MySQL-System which is not really cool for the Django way of coding.
The hint from Sebastian was trying the legacy database access provided by django, which enables you to override naming conventions and to access any already existing db.
This worked very fine, so that we do have admin page for the yoosic system now and are able to create an xml-rpc based function to replace contents of the yoosic site.
In the passed week, I was able to initiate a cooperation with a really cool 20-year-experience-IT-professional.
He will be coming into our office once a week and beeing available as a coach and discussion partner for our partially really young, highly talented guys…
I’m really positive about this and hope that both partys will be living an high level experience exchange…
more news about this here in the next weeks.
just repaired some minor issues this morning on yoosic.com. And in the next days I will be inserting a new flash player for replacing our current mp3-stream solution.
Furthermore I’m thinking about a way, where I can use Django or Symfony to start replacing functions in our current nasty-code-wasted yoosic-app while accessing the current yoosic database.
The only possibility I see is using Symfony by remodelling the current MyISAM-DB-Structur in the schema.yml and the generating the model. Afterwards I will be able to create Ajax-Views, which I can access from yoosic to have it replacing current modules…
Do you see a way using Django? I really would like to prefer this!
Just ran into errors with Lighttpd 1.5, PostgreSQL, Django (trunk) Admin and using memcached for accellerating the page.
The 500er error I got when accessing /admin looked like:
File "/usr/lib/python2.4/site-packages/django/core/cache/__init__.py",
line 60, in get_cache
cache_class = getattr(__import__('django.core.cache.backends.%s' % BACKENDS[scheme], {}, {}, ['']), 'CacheClass')
File "/srv/www/www.tschitschereengreen.com/tts/django/core/cache/backends/memcached.py", line 12, in ?
raise InvalidCacheBackendError("Memcached cache backend requires either the 'memcache' or 'cmemcache' library")
InvalidCacheBackendError: Memcached cache backend requires either the 'memcache' or 'cmemcache' library
I tried several solutions, like the forums and other sources recommended (installing memcached-python bindings, install in cmemcached, etc.). The only thing which worked was replacing memcached by using the “file:///” cache. *Grml!*
After trying several tools for making the translation of a symfony project convenient for our customer, I found the following best practice:
[Update] I missed something. You have to have to change the language code of the English file in the menue. IMPORTANT!
In the today’s meeting we decided to implement Scrum to tap the full potential of strenght of our teamwork.
Scrum is a procedure modell with focus on simple and straight working methods especially concerning agile software developement.
Some advantages of Scrum are:
To the central functions of Scrum belongs the Sprint, which is completely organized by the team. It concerns scetchily the major technical and administrative tasks of the projects and also the requirements which are necessary to fullfill the tasks.
Also important – the daily Scrum Meeting (max. 15min.) which we will extend by a phone call with the customer. The topics should be short and precise.
In the review-phase of scrum the costumer controls the result of the sprint, can synchronise with the developers and can make improvement suggestions.
The retrospective phase follows after a completed sprint to improve the next sprint. The teammembers “look back” and note down important events in the last sprint. It is also possible to use something like a timeline to order events.
All in all in scrum is a really simple method for the organisation of complex structurs. It works with small and also really big teams and can be implement at every point of the project.
As of April, 1st we will start our first scrum-meetings and sprints.
[written by Corii, published by Jerk]
finally just solved big problems I had with symfony - to get it running on lighttpd 1.5 with fcgi-sockets. The resulting lighttpd settings are a pure pain in the … - If you have a better solution for this, let me know. I’m pretty unhappy with these kind of hacks…
$HTTP["host"] == "###TypeYourUrlHere###" {
var.site-root = "/var/www/###TypeYourUrlHere###/web/"
accesslog.filename = var.site-root + "../log/access.log"
alias.url = (
"/" => var.site-root,
)
# from: http://trac.symfony-project.com/wiki/lighttpd
url.rewrite-once = (
"^/(.*\..+(?!html))$" => "$0",
"^/(.*)\.(.*)" => "$0",
"^/([^.]+)$" => "/index.php/$1",
"^/$" => "/index.php"
)
# Handling dynamic content
$HTTP["url"] =~ "^/(?!js|css|images)" {
proxy-core.rewrite-request = (
"_pathinfo" => ( "^(/.*)" => "/$1" ),
"_scriptname" => ( "^/(.*)" => "/$1" )
)
}
# somthing is wrong here. this essential to get
# ajax calls /like/this/url.html working
# this is a really dirty hack
server.error-handler-404 = "index.php",
$HTTP["url"] =~ "backend\.php" {
server.error-handler-404 = "backend.php",
}
}
after hours of trying, here the final config data for my Wordpress/Lighttpd dualism:
lighttpd.conf:
$HTTP["url"] =~ "\.php$" {
proxy-core.balancer = "round-robin"
proxy-core.allow-x-sendfile = "enable"
proxy-core.protocol = "fastcgi"
proxy-core.backends = ( "unix:/tmp/php-fastcgi.sock" )
proxy-core.max-pool-size = 16
}
20-tschitschereengreen.conf
# Wordpress Blog
$HTTP["url"] =~ "^/blog" {
proxy-core.rewrite-request = (
"_pathinfo" => ( "^/blog(/.*)" => "$1" ),
"_scriptname" => ( "^/blog/(.*)" => "/blog/index.php/$1" )
)
url.rewrite = (
"^/blog/(wp-.+)$" => "$0",
"^/blog/xmlrpc.php" => "$0",
"^/blog/sitemap.xml" => "$0",
"^/blog/(.+)$" => "/blog/index.php/$1"
)
server.error-handler-404 = "/blog/index.php"
}
Thanks to Arthur: this site was moved from Symfony to Django, from Apache2 to Lighttpd1.5, from MySQL to PostgreSQL within the last Friday. Arthur prepared the Django installation. The data transformation and server configuration was done by Arthur and myself für Sebs support.
The result: with using memcached the page load time went down from 1-3 second to 50-100ms depending if you do a complete reload (measured on our machines).
Though I need to say that setting up Lighttpd with multiple domains, python and php5 is a true mess! Especially when you do have readable urls…