Ventanazul es un webzine para desarrolladores web publicado por Alexis Bellido.

Puedes contactarme aquí y encontrarme en Facebook Twitter y LinkedIn.

Drupal queries and the IN SQL operator

The Django gunicorn fabfile project

Since I read about Green Unicorn, better known as gunicorn, a Python WSGI HTTP server that goes along very well with Django, I knew I had to try it, and trying it I did. And I liked it. There were many steps to make a server work but overall it was cleaner than other approaches, including the Django deployment using Nginx, Apache and mod_wsgi that I described long time ago. And many reports indicate that a Django setup with gunicorn performs better than one using Apache.

But when you have to setup many servers with the same configuration, the process gets boring and repetitive, and when you're bored you make mistakes. This is the perfect scenario for automating with Python and a Fabric script.

Keep your database in sync with MySQL and PostgreSQL

If you write web applications you may already be using a version control system to keep code in sync between your servers, but what about your MySQL or PostgreSQL database?

Sure, there is replication, one master database server with one or more slaves is a possible case, but that may be overkill for most simple projects. You just want to make sure the database is the same in your development, staging and production servers at a certain time, like after some major changes in code or before a new release.

Worry not my friend as you just need a few quick commands to keep your valuable data in sync. Yes, it's command line time again.

Markdown and url filter enabled

I had noticed that many of your comments included urls but no link and I understand that not everybody is used to thinking and writing on HTML all the time, that's why I just enabled Markdown and a url filter to the comments textarea.

Enjoy.

Is social media taking the comments away?

It seems to me that everyday there are more discussions going on in Twitter and FriendFeed than in regular websites or blogs. I don't have numbers at hand or any other way to support this idea, and maybe I'm wrong, but I'd like to know what you think.

Have you noticed less comments on your sites lately? Are Twitter and FriendFeed taking all the comments away?

Video editing with free software: Kdenlive 0.7.3

Kdenlive with UbuntuLong time GNU/Linux users may know there are two types of applications where we are not there yet compared to other operating systems: games and video editing. Well, the video editing part has started to change with the recent release of Kdenlive 0.7.3.

Kdenlive is a free software video editor that works with both GNU/Linux and FreeBSD, running either KDE or Gnome. It can edit footage from DV, HDV and AVCHD sources and uses other projects, like FFmpeg and the MLT video framework, to get its job done.

Kdenlive has a very simple and easy to understand user interface that will take you from capturing footage to editing and rendering in just a few steps. I've used Kdenlive to produce some short and silly clips and a few one hour long episodes of my videocast In Silico.

I know my video editing needs are basic, they couldn't be considered professional at all, but I'm sure there are many of you with similar needs out there. I usually capture some video from my Panasonic PV-GS80 MiniDV camcorder, add some music, a few titles and render to a format that can be uploaded to one of the many video services online.

Kdenlive with Ubuntu

Let's see how to install Kdenlive.

System76 Starling: a new Ubuntu friendly netbook

System 76 Starling

System76, the company that focuses on Ubuntu based computers, has just launched its first netbook model, the Starling.

Why you should follow me on Twitter?

Your time is valuable and you need valuable content in your Twitter timeline. Here some reasons why you should follow me on Twitter:

  • I just share knowledge and ideas that I think may be helpful for my followers.
  • I spend a lot of time teleworking, programming, designing and consulting on Internet projects. Many useful thoughts from all that turn into tweets.
  • I like to watch good movies, listen to great music and enjoy the best books I can find. Even if your tastes are different than mine you may find something worthy.
  • I follow a very small group of very interesting people. You may find some very smart guys and gals thru me.
  • Once in a while I may have a few questions that you could answer. I may retweet your answer and we both can help a lot of people.
  • If I find your tweets valuable I may follow you. Many of my followers could do so as well.
  • We can become good friends and possibly collaborate on a project later.
  • I keep personal messages in private and won't clutter your timeline.
  • I tweet in both English and Spanish. If you're learning either of those languages this is a good way of doing it.
  • I try to keep updated on the latest news all over the world. You may hear it from me before you watch it on TV or read it on news sites.
  • Finally, I have a good sense of humor so you can mock me and I won't send my goons to your house, or nearest ISP.

Wanna try? Follow me on Twitter

Versión en español: ¿Porqué debes seguirme en Twitter?

Best settings to export video from Adobe Premiere to Dailymotion and Vimeo?

I'm looking for the best settings to export my videos to services like Dailymotion and Vimeo.

Social networking no longer a phenomena

True, we can no longer consider social networking, or should I say social media?, as something restricted to a group of geeks without a life. Social networking has reached Joe and Jane; mom and pop and your kids. It's already changing lives and helping causes all over the world.

In this first episode of In Silico in English I offer a quick look at the evolution of social networks.