Ruby vs Python - Home

/etc/apache2/passenger_pane_vhosts

aptitude install  postgresql-server-8.3-dev postgresql-plperl-8.3

perl  -MCPAN -e shell
cpan> o conf prerequisites_policy follow
cpan> o conf commit
cpan> install DBI Moose IO:Handle Sys::Hostname Sys::Syslog Mail::Sendmail ExtUtils::MakeMaker DBD::Pg Test::Simple Test::Harness Test::More

wget http://bucardo.org/downloads/Bucardo-3.0.9.tar.gz
tar zxvf Bucardo-3.0.8.tar.gz
cd Test-Dynamic-1.3.2/ && perl Makefile.PL && make && make test && sudo make install
cd DBIx-Safe-1.2.4/ && perl Makefile.PL && make && make test && sudo make install
cd Bucardo-3.0.9/ && perl Makefile.PL && make

CREATE USER bucardo SUPERUSER;
CREATE DATABASE bucardo OWNER bucardo;
\c bucardo
CREATE LANGUAGE plpgsql;
CREATE LANGUAGE plperlu;
# мы находимся в папке с bucardo
\i bucardo.schema

CREATE DATABASE db_kyiv OWNER bucardo;
CREATE DATABASE db_lviv OWNER bucardo;
# и для обеих надо будет выполнить
CREATE LANGUAGE plpgsql;
CREATE LANGUAGE plperlu;

\c db_kyiv
CREATE SEQUENCE user_id_seq
increment 2
start 1;
CREATE TABLE users (
    id integer DEFAULT nextval('user_id_seq') PRIMARY KEY,
    name varchar(50)
);
\c db_lviv
CREATE SEQUENCE user_id_seq
increment 2
start 2;
CREATE TABLE users(...

\c bucardo
# базы -- нашем случае мы заведем обе базы на localhost, но это лишь для чистоты эксперимента
INSERT INTO  db(name, dbname, dbhost, dbuser) VALUES ('kyiv','db_kyiv','localhost','bucardo');
INSERT INTO  db(name, dbname, dbhost, dbuser) VALUES ('lviv','db_lviv','localhost','bucardo');
# группы баз (удобнее всего, когда вида master-slave)
INSERT INTO  dbgroup(name) VALUES ('remote_dbs');
INSERT INTO  dbmap(db,dbgroup) VALUES ('lviv','remote_dbs');
# таблицы (мы заносим таблицы одной из сторон, т.е. из нашей пары только одну)
INSERT INTO  goat(db, tablename, pkey, standard_conflict, schemaname) VALUES('kyiv', 'users', 'id', 'latest', 'public');

INSERT INTO herd(name) VALUES ('main');
INSERT INTO herdmap(herd,goat) SELECT 'main', id FROM goat WHERE db='kyiv' AND tablename IN ('users');

INSERT INTO  sync (name,source,targetdb,synctype,checktime,disable_triggers,disable_rules) VALUES ('main_sync','main','lviv','swap','10 minutes', 'replica', 'replica');

./bucardo_ctl start "First start"
Checking for existing processes
Removing /var/run/bucardo/fullstopbucardo
Starting Bucardo
ps ax | grep Bucardo
 6517 ?        S      0:00 Bucardo Master Control Program v3.2.5. Active sync:main_sync
 6522 ?        S      0:00 Bucardo Controller. Sync "main_sync" (swap) for source "main"
 6524 ?        S      0:00 Bucardo Kid. Sync "main_sync": (swap) "kyiv" -> "lviv"

bucardo=# \c db_lviv 
You are now connected to database "db_lviv".
db_lviv=# insert into users(name) values ('Львовский юзер');
INSERT 0 1
db_lviv=# \c db_kyiv
You are now connected to database "db_kyiv".
db_kyiv=# select * from users;
 id |      name      
----+----------------
  2 | Львовский юзер
(1 row)

db_kyiv=# insert into users(name) values ('Киевский юзер');
INSERT 0 1
db_kyiv=# update users set name='Львовский пузер' where id=2;
UPDATE 1
db_kyiv=# \c db_lviv
You are now connected to database "db_lviv".
db_lviv=# select * from users;
 id |      name       
----+-----------------
  1 | Киевский юзер
  2 | Львовский пузер
(2 rows)

KID Got a notice for main_sync: kyiv -> lviv
KID Source delta count for public.users: 1
...
KID Total delta count: 1
KID No conflict, source only for public.users.id: 1
KID Action summary: 1:1
KID [1/1] public.users INSERT source to target pk 1
KID Issuing final commit for source and target
KID Marking as done in the q table, notifying controller
KID Finished syncing. Time: 0. Updates: 0+0 Inserts: 0+1 Deletes: 0+0 Sync: main_sync. Keepalive: 1
...
KID Got a notice for main_sync: kyiv -> lviv
...
KID No conflict, source only for public.users.id: 2
KID Action summary: 1:1
KID [1/1] public.users UPDATE source to target pk 2
...

local1.* -/var/log/bucardo.log

-<devil@Hor.local:~/Works/Ruby>-
-<%>- sudo /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/bin/gem install open4
Password:
Bulk updating Gem source index for: http://gems.rubyforge.org/
Bulk updating Gem source index for: http://gems.github.com/
Successfully installed open4-0.9.6
1 gem installed

-<devil@Hor.local:~/Works/Ruby>-
-<%>- git clone git://github.com/Caged/gitnub.git
Initialized empty Git repository in /Users/devil/Works/Ruby/gitnub/.git/
remote: Counting objects: 1299, done.
remote: Compressing objects: 100% (682/682), done.
remote: Total 1299 (delta 700), reused 1071 (delta 558)
Receiving objects: 100% (1299/1299), 2.88 MiB | 396 KiB/s, done.
Resolving deltas: 100% (700/700), done.
-<devil@Hor.local:~/Works/Ruby>-
-<%>- cd gitnub
-<devil@Hor.local:~/Works/Ruby/gitnub>-
-<%>- git submodule init
Submodule 'lib/grit' (git://github.com/mojombo/grit.git) registered for path 'lib/grit'
-<devil@Hor.local:~/Works/Ruby/gitnub>-
-<%>- git submodule update
Initialized empty Git repository in /Users/devil/Works/Ruby/gitnub/lib/grit/.git/
remote: Counting objects: 3392, done.
remote: Compressing objects: 100% (2177/2177), done.
remote: Total 3392 (delta 1243), reused 3261 (delta 1169)
Receiving objects: 100% (3392/3392), 1.80 MiB | 184 KiB/s, done.
Resolving deltas: 100% (1243/1243), done.
Submodule path 'lib/grit': checked out '6b86674364a7adf98fff10154db7fc706326271d'
-<devil@Hor.local:~/Works/Ruby/gitnub>-
-<%>- xcodebuild
=== BUILDING NATIVE TARGET GitNub WITH THE DEFAULT CONFIGURATION (Release) ===

Checking Dependencies...

---------- skipped -------------

Touch /Users/devil/Works/Ruby/gitnub/build/Release/GitNub.app
    cd /Users/devil/Works/Ruby/gitnub
    /usr/bin/touch -c /Users/devil/Works/Ruby/gitnub/build/Release/GitNub.app
** BUILD SUCCEEDED **

-<devil@Hor.local:~/Works/Ruby/gitnub>-
-<%>- cp -rf build/Release/GitNub.app /Applications/
-<devil@Hor.local:~/Works/Ruby/gitnub>-
-<%>- cp nub /usr/local/bin/

-<devil@Hor.local:~/Works/Ruby/gitnub>-
-<%>- nub

-<devil@Hor.local:~/Works/Ruby/gitnub>-
-<%>- git config github.user Caged
-<devil@Hor.local:~/Works/Ruby/gitnub>-
-<%>- git config github.repo gitnub

root@host ~ # apachectl graceful

Include "/etc/apache2/passenger_pane_vhosts/*.conf"

197  def passenger_installed?
198    `/usr/sbin/httpd -t -D DUMP_MODULES 2>&1`.include? 'passenger_module'
199  end

root@host ~ # gem install passenger
Building native extensions.  This could take a while...
Successfully installed passenger-2.0.1
1 gem installed
Installing ri documentation for passenger-2.0.1...
Installing RDoc documentation for passenger-2.0.1...
root@host ~ # passenger-install-apache2-module
Welcome to the Phusion Passenger Apache 2 module installer, v2.0.1.

This installer will guide you through the entire installation process. It
shouldn't take more than 3 minutes in total.

Here's what you can expect from the installation process:

 1. The Apache 2 module will be installed for you.
 2. You'll learn how to configure Apache.
 3. You'll learn how to deploy a Ruby on Rails application.

Don't worry if anything goes wrong. This installer will advise you on how to
solve any problems.

Press Enter to continue, or Ctrl-C to abort.

LoadModule passenger_module /opt/ree/lib/ruby/gems/1.8/gems/passenger-2.0.1/ext/apache2/mod_passenger.so                                                                 
PassengerRoot /opt/ree/lib/ruby/gems/1.8/gems/passenger-2.0.1                                                                                                            
PassengerRuby /opt/ree/bin/ruby                                                                                                                                          
PassengerLogLevel 3                                                                                                                                                                  
PassengerUserSwitching on                                                                                                                                                            
PassengerDefaultUser wwwrun                                                                                                                                                          
PassengerMaxPoolSize 20 

<VirtualHost xxx.xxx.xxx.xxx:80>                                                                                                                                                        
  ServerName example.com                                                                                                                                                          
  ServerAlias www.example.com                                                                                                                                                     
  ServerAdmin admin@example.com                                                                                                                                                
  DocumentRoot "/srv/www/virtuals/example.com/public/"                                                                                                                                        
  ErrorLog "/srv/www/logs/example.com-error.log"                                                                                                                                      
  CustomLog "/srv/www/logs/example.com-access.log" combined                                                                                                                           

    <Directory "/srv/www/virtuals/example.com/public/">                                                                                                                                                                                                                                                                      
        AllowOverride All                                                                                                                                                            
        Order allow,deny                                                                                                                                                             
        Allow from all                                                                                                                                                               
    </Directory>                                                                                                                                                                     
</VirtualHost>

root@host:~ # /opt/ree/bin/passenger-memory-stats 
------------- Apache processes --------------
PID   PPID  Threads  VMSize    Private  Name
---------------------------------------------
7214  9001  1        302.3 MB  1.6 MB   /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL -DAWSTATS -DSTATUS
7216  9001  1        302.4 MB  2.6 MB   /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL -DAWSTATS -DSTATUS
7233  9001  1        302.5 MB  2.8 MB   /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL -DAWSTATS -DSTATUS
7367  9001  1        302.4 MB  2.5 MB   /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL -DAWSTATS -DSTATUS
7370  9001  1        302.3 MB  1.9 MB   /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL -DAWSTATS -DSTATUS
7375  9001  1        302.2 MB  1.4 MB   /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL -DAWSTATS -DSTATUS
7380  9001  1        302.5 MB  2.6 MB   /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL -DAWSTATS -DSTATUS
7382  9001  1        302.4 MB  2.6 MB   /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL -DAWSTATS -DSTATUS
7386  9001  1        302.2 MB  1.5 MB   /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL -DAWSTATS -DSTATUS
7387  9001  1        302.1 MB  1.3 MB   /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL -DAWSTATS -DSTATUS
7390  9001  1        301.6 MB  0.4 MB   /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL -DAWSTATS -DSTATUS
7394  9001  1        302.2 MB  1.5 MB   /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL -DAWSTATS -DSTATUS
7879  9001  1        301.6 MB  0.4 MB   /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL -DAWSTATS -DSTATUS
9001  1     1        301.3 MB  0.4 MB   /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL -DAWSTATS -DSTATUS
### Processes: 14
### Total private dirty RSS: 23.54 MB

--------- Passenger processes ----------
PID    Threads  VMSize    Private  Name
----------------------------------------
8105   1        75.7 MB   6.6 MB   Passenger FrameworkSpawner: 2.1.0
8134   1        82.9 MB   8.7 MB   Passenger ApplicationSpawner: /srv/www/virtuals/example.com/
8136   1        103.7 MB  25.3 MB  Rails: /srv/www/virtuals/example.com
32446  39       58.4 MB   4.9 MB   /opt/ree/lib/ruby/gems/1.8/gems/passenger-2.0.1/ext/apache2/ApplicationPoolServerExecutable 3 /opt/ree/lib/ruby/gems/1.8/gems/passenger-2.0.1/bin/passenger-spawn-server  /opt/ree/bin/ruby  /tmp/passenger_status.9001.fifo
32449  1        24.5 MB   7.7 MB   Passenger spawn server
### Processes: 5
### Total private dirty RSS: 53.08 MB

/0 0.0.0.0 4294967296
/1 128.0.0.0 2147483648
/2 192.0.0.0 1073741824
/3 224.0.0.0 536870912
/4 240.0.0.0 268435456
/5 248.0.0.0 134217728
/6 252.0.0.0 67108864
/7 254.0.0.0 33554432
/8 255.0.0.0 16777216
/9 255.128.0.0 8388608
/10 255.192.0.0 4194304
/11 255.224.0.0 2097152
/12 255.240.0.0 1048576
/13 255.248.0.0 524288
/14 255.252.0.0 262144
/15 255.254.0.0 131072
/16 255.255.0.0 65536
/17 255.255.128.0 32768
/18 255.255.192.0 16384
/19 255.255.224.0 8192
/20 255.255.240.0 4096
/21 255.255.248.0 2048
/22 255.255.252.0 1024
/23 255.255.254.0 512
/24 255.255.255.0 256
/25 255.255.255.128 128
/26 255.255.255.192 64
/27 255.255.255.224 32
/28 255.255.255.240 16
/29 255.255.255.248 8
/30 255.255.255.252 4
/31 255.255.255.254 2
/32 255.255.255.255 1
# => 0..32

In [4]: [("%s" % i, "/%s - %d" % (i, pow(2, 32-i))) for i in range(23, 31)]
Out[4]: 
[('23', '/23 - 512'),
 ('24', '/24 - 256'),
 ('25', '/25 - 128'),
 ('26', '/26 - 64'),
 ('27', '/27 - 32'),
 ('28', '/28 - 16'),
 ('29', '/29 - 8'),
 ('30', '/30 - 4')]

Out[28]: 
['/0 0.0.0.0 4294967296',
 '/1 128.0.0.0 2147483648',
 '/2 192.0.0.0 1073741824',
 '/3 224.0.0.0 536870912',
 '/4 240.0.0.0 268435456',
 '/5 248.0.0.0 134217728',
 '/6 252.0.0.0 67108864',
 '/7 254.0.0.0 33554432',
 '/8 255.0.0.0 16777216',
 '/9 255.128.0.0 8388608',
 '/10 255.192.0.0 4194304',
 '/11 255.224.0.0 2097152',
 '/12 255.240.0.0 1048576',
 '/13 255.248.0.0 524288',
 '/14 255.252.0.0 262144',
 '/15 255.254.0.0 131072',
 '/16 255.255.0.0 65536',
 '/17 255.255.128.0 32768',
 '/18 255.255.192.0 16384',
 '/19 255.255.224.0 8192',
 '/20 255.255.240.0 4096',
 '/21 255.255.248.0 2048',
 '/22 255.255.252.0 1024',
 '/23 255.255.254.0 512',
 '/24 255.255.255.0 256',
 '/25 255.255.255.128 128',
 '/26 255.255.255.192 64',
 '/27 255.255.255.224 32',
 '/28 255.255.255.240 16',
 '/29 255.255.255.248 8',
 '/30 255.255.255.252 4',
 '/31 255.255.255.254 2',
 '/32 255.255.255.255 1']
# а если добавить в конце [::-1] то получим CIDR задом на перед.

#include <QTextCodec>
...
int main(int argc, char *argv[])
{
    QApplication app(argc, argv);
    QTextCodec::setCodecForTr(QTextCodec::codecForName("utf-8"));
              ...
}
тогда
{
    ...
    QPushButton *quit = new QPushButton(tr("выход"));
    painter.drawText(200, 200, tr("привет"));
    ...
}

Ruby vs Python - Home

Мы вернулись!

Асинхронная мульти-мастер репликация в PostgreSQL

Задача

Теория (это где почти все грустно)

Выход есть

Практика

Сестра, скальпель!

Does it bark?

Это еще не все

GitNub - github на вашем маке

Django релиз!

удобная разработка rails приложений на MacOS X

Axaj.Updater && IE 7 bug(?)

Анотация

Часть первая "Bug"

Часть вторая, заключительная "Cache"

mod_rails!

Лирическое вступление

Установка mod_rails и настройка apache

Виртуальный хост

Выводы :)

Печатаем маны

Срочное обновление руби

Описание

Воздействие

Уязвимые версии

Учтите!

Python 2.6 и Python 3.0

smslink rails plugin

Свершилось!

Ruby: CIDR в одну строку

Python: CIDR в одну строку :P

сайты, сайты, сайты....

Qt: русский под linux'ом и offtopic'ом