Сообщения

Сообщения за ноябрь, 2017

PostgreSQL 9.3 What's new?

Изображение
Hello, habrachelovek! Not so long ago there was a release of PostgreSQL 9.3 and I would like to present You with the most important innovations for the client part, which may be useful to You. In this article, we'll cover: the the materialiserades presentation the updatable views the triggers on events the text representation the lateral joining the are modified by external tables the functions and operators for working with type JSON Materialiserades representation Materialiserades representation of the physical database object containing the results of some query. Undoubtedly, one of the most anticipated innovations. Let's see how to work with it in PostgreSQL . Create a directory of authors and reference books, with a link to the author: the CREATE TABLE author ( id serial NOT NULL, first_name text NOT NULL, last_name text NOT NULL, Pk_author_id CONSTRAINT PRIMARY KEY ( id ), Uk_author_name CONSTRAINT UNIQUE ( first_name, last_name ) );

Webinar: What are regular expressions?

Изображение
This is the fourth webinar of the cycle free webinars on automation testing. The video (duration-1 hour 10 min.): Topics and details of the video under the cut Webinar presenter, Michael Polyarush which talks about the basics of regular expressions and demonstrates that they work on practical examples. the 00:00 – 02:37 Entry. The agenda and purpose of the webinar. the 02:38 – 04:35 the History of regular expressions the 04:36 – 10:54 What are regular expressions? Definition. An example of pasanga log the 10:55 – 14:37 regular expression Syntax. The normal (literal), and special characters. Escaping special characters. the 14:38 – 17:09 character Sets (classes); [0-9], [Aa] the 17:10 – 17:54 Special metacharacters-reduction. \d \d \s \S \w \W the 17:55 – 20:00 specifying a position in the search: the beginning and the end of the row, the beginning and the end of a word the 20:01 – 20:24 Grouping

GSA: Dissecting Google Search Appliance virtual machine

Изображение
Recent years, interest in reading about personal search engines in cheerful yellow boxes for Google, I periodically googled according to GSA, Google Search Appliance, reverse engineering, and it must be confessed, hack, DIY, disk dump, etc. but nothing But official press releases and correspondence of the happy (?) owners with a support group, I have not seen. Sometimes sounded timid on forums questions like "how would root me to" or "to get into the GSA via ssh" but on all such questions the answer was the same — only support group, Google knows the passwords. And not tell anyone. Surprisingly, I haven't met in Internet no attempts to collect a "Hackintosh" on the engine of Google or on live code to understand the algorithm of page ranking. The situation slightly changed in 2008, when the wave of euphoria from virtualization, Google rolled out the VGSA is a free virtual machine for Vmware is limited to 50 thousand documents license. Howe

PostgreSQL interaction with external services to store images

Изображение
Good time of day. When working with a database for a website sometimes a situation arises when you have to choose how and where to store the image. Among the possible options usually include: the the images are entirely in the database the images are in the file system, stored in the database file name the images are stored in external specialized service Though PostgreSQL and provides the possibility of storing in a DB file (in bytea the fields, or through large objects ), this is the least best option in terms of speed and memory consumption. Another common practice is to store images as files on a disk that site is the path to the image. Of the benefits — the possibility of caching or use a specialized file system. And the third option for images a separate service, which can be caching, masturbirovala on the fly, change the format. Try to interact PostgreSQL with this service. Implementation of Outline a little picture. We have a http-service, type this , f

10 popular games and apps for Ubuntu in may 2012 (repository UALinux)

Изображение
Want to propose to be distracted from watching the football championship, and learn new games and apps that statistically appeals to the repository scored the most points in the last month of spring. From the testimony of statistics as last time was excluded games and apps listed in the announcements: here: 10 popular games and apps for Ubuntu in April 2012 here: 10 popular games and apps for Ubuntu in March 2012 here: 10 most popular games for Ubuntu in February 2012 due to massive time with Habra statistic is not entirely accurate. Pay attention that repository are already available for owners of Ubuntu 12.04 . So, here are the results for may: Popular games: 1. Urban Terror is a multiplayer shooter game 2. Enemy Territory: Quake Wars is a strategic online shooter 3. The Ur-Quan Masters — Intergalactic adventure 4. The Babylon Project — space battles 5. Oolite — a space trading simulator and battles 6. Tile Racer — 3D stunt racing 7. Spr

The consequences of a ban or, again, the blackjack and hookers

Изображение
the Story, which can lead to closure working from Internet "entertainment" sites and depriving stupid people of their joys. And of the fact that designers and engineers — no cut off from the earth loafers, able only to put spokes in the wheels (as in all seriousness I think many coders) — but still important people :) This is lazy to read — just link to another clone bashorga . And it is interesting to see how he appeared and "fuck, finally?"... It all began quite banal — chief suddenly decided to close for the employees access to entertainment sites. Well, we reacted to this with understanding — Buhi, the impression went from "odinas: accounting Department" to some "odnoklas: accounts": "Classmates" from the screens of their computers simply did not go. But the fact that the list of "forbidden" sites and get bashorg(ru) — such podlyanki we did not expect. In our Department it's been a long tradition to look th

One ring

Изображение
the notion of a personal computer become obsolete, to replace him gradually personal reality. Glasses of augmented reality replace the monitor. But, the idea for a potential device that replaces the mouse, and using, for example, 8pen and the keyboard. Of course, also the mouse can be replaced by tracking the gaze and keyboard — voice control, but lacks something tangible. And what could be more tangible than the fingers. It remains only to learn to read their information. The first thing that comes to mind is a sensitive gloves. But there is a little better ring to capture the sound of friction of his fingers. Expected to get dressed on the right the average and be similar to this picture from Wikipedia. The principle of operation is the following. From a sound stand out and recognized patterns of movements(taps and swipes) that in the present state of AI should be quite feasible. But patterns aren't everything. Why not go ahead and make a full UI for manipulating m

Experience of attracting customers in a highly competitive market: the story of a small company

we will talk about the company that is engaged in service of computers in St. Petersburg. As the target audience of this service is very far from Karamira, I believe that the hub "I PR" is not suitable: the main point of this post is not advertising our services, and discussion of strategies for the promotion of new companies in the old markets. Article is not for SEO professionals, it is describing the experience from the point of view of company management, not SEO specialist. Work area our company — computer services and — more recently — cloud solutions (in other words, setting up private cloud infrastructure for rapid deployment of virtual machines by the customer). Despite the fact that three years ago habré was discussion about the questionable novelty of the first of these services, inviting external companies for maintenance of it infrastructure practiced in St. Petersburg for almost twenty years: I personally know people that raised this business from sc

.ME – when, why, what and how?

Изображение
you Have the idea for a brilliant Internet service and you come from for its implementation? One of the first questions that you have: what to call it and what domain (brand) to use for its promotion. If you go abroad you are not going it is best to look in the area .Russia .EN. But if the mind walks the idea that we must, sooner or later, will reach the international level, can be considered .ME. Why not .COM you ask? It is possible and .COM but there are already registered more than 180 million domain names, and not every startup can afford the price in the first Internet zone. .IU launched in 2008, thanks to the intensive work of the Montenegrin registry has already managed to declare itself to the whole world. To reduce long links Facebook, Wordpress, StumbleUpon, Delicious, Time, and many other global giants are using FB.ME, WP.ME, VK.ME, D. ME, TI.ME... Among the top sites, you can find Demonoid.Me and About.Me. First, by the way, moved on .ME .COM fleeing f

"Runet today", July 16, 2012. Experts of issue: Anatoly Denisov, Oleg Ulanski

In the Studio "Finam FM" Anatoly Denisov, chief editor of the CMS Magazine; Oleg Ulansky, CEO of the children's portal Tvidi.ru. Together with the lead, Maxim Spiridonov, they speak about the sale once "loud" of a startup in the field of Web 2.0, the partnership between the companies "Rambler" and "2GIS", the reasons why Twitter to abandon aspirations to go public, as well as about the most controversial news of the past weeks, about the so-called law about "black lists" of Internet resources. 1. Social Internet service Digg was acquired by Betaworks for 500 thousand dollars. — Why the service was sold for so little money? — What is the future of Web 2.0? 2. Of the company "2GIS" and "Rambler" entered into a partnership agreement, which requires the use of the booking service "Rambler-cashier" to purchase movie tickets using the online map 2GIS. — How much will be needed

Fake S3 for offline development and saving money

Curtis Spencer (Curtis Spencer) with colleagues from the Spool, the company has developed a lightweight server Fake S3 , which behaves like a real Amazon S3 and helps you test your projects, not chasing data to the cloud and not spending money on traffic. Besides, for testing Fake S3 is safer, because it works locally. Spencer said that the Fake S3 they saved about $1000 in the last month alone, the traffic payment. / > Installation the gem install fakes3 To start the server you need to specify the host and port the fakes3 -r /mnt/fakes3_root -p 4567 Example client code the require 'rubygems' require 'aws/s3' include AWS::S3 AWS::S3::Base.establish_connection!(:access_key_id = > "123", :secret_access_key = > "abc", :server = > "localhost", :port => "10001") Bucket.create('mystuff') ('a'..'z').each do |filename| S3Object.store(filename, 'Hello World', 'm

Anniversary BTCsec.com

Изображение
Exactly a year ago, 31.07.2011 was a website devoted to Bitcoin-themed — BTCsec.com . The website was made in one evening on the knee, even laid out tables for speed, and was a few HTML pages. It was the beginning. For details on the history of its creation, support and development, ask a cat. I promise all sorts of statistics, description of the met rake, tips, and other cookies How it all began: It all started with the notes on the blog of overclocking website that described a way of earning on the cards. My conservative inner voice "is-divorce-Scam -!" memory that defended the diploma on metacomputing computing, and anything is possible there, the note was read. Then read two more times until complete absorption, because the material is a little beaten out from the slender ranks of the it articles, to which I am accustomed. The first attempt to engage in mining on this statement showed that it works, BTC dropped and, not without dancing, but are con