Archive for July, 2009

Top 3 Linux HTML editors

This post is dedicated to quality html editors for Linux and Ubuntu operating system in particular. You may think that nowadays nobody uses offline editors as there are so many content management systems (CMS) like Drupal (my favourite one), Wordpress, Joomla etc. which contain embedded visual html editors. But today I made sure myself that sometimes it’s real pain to draw a 10×20 table using Wordpress’s editor…

Text editors like gedit, emacs, nano or vi will certainly live forever but thankfully there are numerous visual html editors for my Ubuntu :) They are sometimes called WYSIWYG editors, it mean “What You See Is What You Get”.

1. Quanta Plus

This is KDE/Qt visual html editor available as binary package for numerous Linux distributions
including Debian and Ubuntu. From developers’ site:

Quanta Plus is a highly stable and feature rich web development environment.
The vision with Quanta has always been to start with the best architectural
foundations, design for efficient and natural use and enable maximal user
extensibility.

In order to install it in Debian/Ubuntu run the following CLI command:

sudo apt-get install quanta

Fedora, Centos, Redhat users type this:

sudo yum install kdewebdev

I found Quanta html editor extremely useful, this is just an outstanding application of this
field.

2. Bluefish

Bluefish HTML editor logoBluefish is a powerful editor targeted towards programmers and webdesigners,
with many options to write websites, scripts and programming code. Bluefish
supports many programming and markup languages, and it focuses on editing
dynamic and interactive websites.

I found this really versatile html editor. Besides HTML/CSS it handles C,
Java, Perl, Python, XML and others.

Ubuntu and Debian users type:

sudo apt-get install bluefish

Fedora/Redhat/Centos:

sudo yum install bluefish

Gentoo:

emerge bluefish

3. Screem

SCREEM is a web development environment. It’s purpose is to increase
productivity when constructing a site, by providing quick access to commonly
used features. While it is written for use with the GNOME desktop environment
in mind it does not specifically require you to be running it, just have the
libraries installed.

This is one of the most user-friendly Gnome HTML editor. Its simple interface
brings extremely powerfull HTML editor so if like minimalistic design Screem
is your choice.

Update: below is the bottom line from Linux.com’s review of three Linux HTML editors (Quanta Plus, Blowfish,
Screem). I found that review after I wrote this post.

  • If you use GNOME, use Screem. It’s a fast, simple, and powerful tool for web editing. However, it does not have the large feature sets that Bluefish and Quanta Plus have, especially for languages other than those directly related to Web page editing.
  • If you use GNOME and need the more powerful features of Quanta Plus, load the required libraries and run it.
  • If you use KDE and want a code editor, choose Quanta Plus. Ignore the WYSIWYG capabilities and take advantage of the tremendous editing capabilities, especially for CSS style sheets.
  • If you use Xfce, Quanta Plus should run fine. Screem would still require loading additional libraries.
  • Finally, if you use GNOME, find that Screem does not meet all your needs, and you don’t want to bother with loading the KDE-native Quanta Plus, then load Bluefish. It is nearly as capable as Quanta Plus, but will run well without a lot of fussing with libraries.

Google Chrome Operating System

google-chrome os logoHere is astonishing news I came across today at Google Official Blog:

We’re announcing a new project that’s a natural extension of Google Chrome — the Google Chrome Operating System. It’s our attempt to re-think what operating systems should be.

Google Chrome OS is an open source, lightweight operating system that will initially be targeted at netbooks. Later this year we will open-source its code, and netbooks running Google Chrome OS will be available for consumers in the second half of 2010. Because we’re already talking to partners about the project, and we’ll soon be working with the open source community, we wanted to share our vision now so everyone understands what we are trying to achieve.

The software architecture is simple — Google Chrome running within a new windowing system on top of a Linux kernel.

Read more >>

Another pulications on the topic:

1. Alas, poor Microsoft at PCWorld
2. Google Chrome: Lookout Windows and OS X at Gizmodo
3. Google Chrome lives at arctechnica

Postgresql: show tables, show databases, show columns

postgresql logoPostgreSQL is one of the best database engines for an average web project and many who moves to psql from mysql (for example) often ask the following questions: what  is the analog of “show tables” in postgres? or how can I get the list of databases in postgres like “show databases” in mysql? The answers are short:

mysql: SHOW TABLES
postgresql: \d
postgresql: SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';

mysql: SHOW DATABASES
postgresql: \l
postgresql: SELECT datname FROM pg_database;

mysql: SHOW COLUMNS
postgresql: \d table
postgresql: SELECT column_name FROM information_schema.columns WHERE table_name ='table';




Friendly Sites:Who is behind Linux Screw?
Aspiring Sysadmin | GeekyBits³ | Bash Cures Cancer | TOTMS
Linux Operating System | Small Linux Deployments | My SysAd Blog
The Danesh Project | ZEPY | Linux config Wiki | Planet Sysadmin
The Sys Admin | {buhay sysad} | a non-geek's linux notes
Linux HOWTOs, Tutorials & Projects with Adam Palmer | LinuxAlt.Com
My name is Artem Nosulchik (artiomix AT gmail DOT com) and I'm Linux/Unix, Cisco systems engineer. The main idea of Linux Screw is to share relevant knowledge, skills and observations over The Web. Here you can find a lot of information related to different Linux distributions, FreeBSD, IOS as well as a other Open Source around staff. Read more ››