Grand opening ;)

Now I create this blog. Looks fine, isn't it?

Popular posts from this blog

What is GPCL?

GPCL is an object-oriented library for PHP, developed by me and used last ears. Today I write an introduction about GPCL . In few words, with GPCL you can write: include("documents.php"); class MyDoc extends TDocument { function __construct($title) { parent::__construct($title); $this->body->AddHeading(1)->content = "Hello, World!"; } } $doc = new MyDoc("Welcome!"); $doc->PrintAll(); On output you get well-formatted HTML document with "Hello, World" heading and "Welcome" Title.
Read more

One billion records table in Postgresql

I have a simple table in Postgersql database with character key. CREATE TABLE public.zero_hids ( hexblock character(32) COLLATE pg_catalog."default" NOT NULL, hid bigint, CONSTRAINT zero_hids_pkey PRIMARY KEY (hexblock) USING INDEX TABLESPACE alcal ) It is required to insert into this table 1000000000 unique records by loading from CSV file. We can split this file to 5 parts by 200 millions each and insert it from command line: !/bin/bash time psql --port=5433 -d db1 -c "COPY zero_hids FROM '/tmp/table0.csv' delimiter AS ',' HEADER CSV" ... time psql --port=5433 -d db1 -c "COPY zero_hids FROM '/tmp/table4.csv' delimiter AS ',' HEADER CSV" Size of each part is around 9 Gigabytes. Allowed memory limit to Postgresql is 32Gb. Here is results: COPY 200000000 real 55m16.461s user 0m0.040s sys 0m0.008s COPY 200000000 real 89m48.861s user 0m0.048s sys 0m0.016s COPY 200000000 real 202m21.283s user 0m0.04...
Read more

Install and configure Exim 4 mail server in Debian 8

One of friends ask me to configure mail in VPS to send messages via web form. He using Wordpress, and can't write custom PHP code to send mail directly via SMTP. Only one way is acceptable here: to use PHP mail() function. Okay, in this case we need a mail server on VPS. I like Exim. To install Exim, run: apt-get install exim4-base After this, run configuration tool: dpkg-reconfigure exim4-config Make selections with using arrow keys, select “Ok” with tab key (note again, server will setup only for send mail): Select: ‘internet site; mail is sent and received directly using SMTP’ Enter FQDN: yourdomain.tld SMTP Listener: enter 127.0.0.1; ::1 Mail destinations - yourdomain.tld, local hostname, localhost.localdomain, localhost Relay Options: Leave blank Follow up Screen to Relay Options: Leave blank DNS Queries: Keep DNS queries to a minimum? select “No” Delivery method: Select “Maildir format in home directory” Choose default unsplit config file by entering “No...
Read more