computer express

Continuing theme use dynamic SQL, I want to tell you about one useful tool implemented by me in one of the current projects. It will be about the duplicates in the directories. Under duplicates, in this article, I understand entries made in the directories repeatedly, for example as a result spelling errors when entering names. The essence of the proposed approach is to give the opportunity to declare any entry of the directory is a duplicate of an existing one. As a result, the duplicate record will be deleted, and all references to it are fixed so that they began to refer to the correct entry. Also, it is very important to provide the opportunity to revert such changes if they are made by mistake. Let's start with the tables to store technical data: Service table create table mg_table ( table_name varchar(100) not null, pk_name varchar(100) not null, primary key(table_name) ); create sequence mg_action_seq; create table mg_action ( id bigint default nextval(

One day in the far distant past I think that most of us survived not too many memories from early childhood. Anyway, to me this is the case, but there is something that remains in memory forever, zapechatlevshie in her bright moments. Often it is a joyful event, because we remember good is better than bad. When I, freedom-loving, adventurous, and learning, was imprisoned in kindergarten, I was indignant. To soften my righteous anger, his father employed at that time by the artist, agreed with the administration of the kindergarten and on the walls of corridors and rooms in which we were imprisoned, there was strange creatures. As shown by further research conducted by the scientific Board of independent experts toddlers, those creatures were called animals. For the most part they were representatives of the African savanna: Flamingo, parrot, elephant, giraffe, Zebra, wildebeest, Rhino and many others. This knowledge quickly spread among the prisoners of the younger gr

Microsoft lost to the Yandex fourth place in the world search by number of search queries. According to ComScore statistics, Microsoft has moved into fifth place, behind the search engine from Russia. In Microsoft we are talking not only about the search engine Bing. The statistics include also other websites and services such as microsoft.com, Windows Live, etc. In the same Yandex take into account not only search, but also other services such as maps, traffic, cars, etc., the First three looks similar. It's Google, Baidu and Yahoo! For the first time this information became known in November, when Yandex processed 4.62 billion search queries, while Microsoft has processed 4,48 billion search queries. But this meant that every company has a share of 2.6% of the total world search. Yandex continued to increase their advantage and in December the numbers were as follows: Yandex treated of 4.84 billion queries(2.8 percent) and Microsoft 4.48 billion requests(2,5%). Fo

Relational database — the beast is relatively unknown, and has a reputation as a generator of problems. Not that problems didn't exist, but as with other tools, most often the difficulties arise from the inability of their (RDBMS) to cook. To cook with one article not to learn, but one dish sdyuzhil. I tried out the skeleton, a set of scripts, which you can do your schema in PostgreSQL and test them using pgTAP: github.com/C-Pro/pg_skeleton And as a nice bonus I screwed the case to Travis, that you even and CI was already at the start :) For installation we need: the the PostgreSQL >= 9.2 with dev headers (have to compile the extension for postgres) the pgTAP (by extension) the pg_prove to run tests So, in order: If PostgreSQL is not already installed — put. If you have Ubuntu or Debian, I recommend to plug in their repository apt.postgresql.org (for instructions on connecting, see here: wiki.postgresql.org/wiki/Apt ). Immediately warn — on Ub

Hello, %username%! Today I want to tell you about such concept as "start-up". Only I'm not going to paint the life in pink. However, don't wait and gray shades. Unlike most of the inhabitants of "Habra" I have a professional education in Economics. And you know what "start-up" experience. And behind not only has a negative or positive experience. There are victories and failures. Not only mine, but my customers (worked for some time on themselves, but now closed company — from my limited Finance their business at the proper level is not yet implemented). This is what I want to tell. However, this article is, in particular, the "analysis" of events over the last two years from the point of view of a person slightly understand the economy. Let's start... "Start-up" as a trend For anybody not a secret that the "start-up" is today's trend, fashion trend. What amazes me, no one is trying to analyze why

full-text search Library Lucene provides the ability to organize search by text documents. There are also tools with which you can search "similar" chemical structures, such as OpenBabel. Sometimes you may need to combine these two types of search into a single "canvas". For example, if you want to create a system that can answer such queries: find substance in the text which has the word "amino acid", structurally similar to indole (it is expected that we will find the amino acid tryptophan). This article describes the solution to this problem based on full-text engine Lucene. As you know, based on full-text search is the inverted index construction. The document text is split into individual words, each of which builds a list of documents that contain the word. Usually in addition to the list of documents for a given word, the index contains the position of the words in each document. Search for similar molecules in databases can be based o

it has been nearly two months since the publication on habré of the first introductory article about the project of MajorDoMo and I have some news. Just this week was released update version 0.1.8 b, which includes a number of minor changes and some quite interesting innovations, which I would like you to meet. Scene The interface works with the Smart Home via the menu system was and still is quite a comfortable. Especially if you have to work on the small screen of a smartphone. However, if we have the screen bigger, why not to use it more efficiently. After thinking a while, I came to the concept of creating scenes. So, what constitutes a scene. The stage is, first and foremost, a great space with a background image, which should set the context. As background, it is logical to use the plan area (room), but the background could be a photo (of the facade) or a neutral image (Wallpaper). Scenes, by the way, can be any number between and easily switch. Nex

After the release of the 2000 icons FatCow more than a year . In her fourth year of drawing. the Page called for 560,096 (288,511+235,221+36,364) visitors . To reach 3500 icons, the works will last until February 2013. If you add the size of 64x64, then to mid-2015. While invested $76778 and 2000 hours. Then put 3000 icons , a week before the release on the official website, because the owners of the cows (Bluehost) busy buying crocodile ( HostGator ). / > To understand which icons are the most unique in the world, had to sort 7422 icons. The result did not disappoint... and it turned out that the percentage of unique icons 85,53% cows , 55,90% James and 68,59% from Yusuke. 17.15% — so % unique icons more Fatcow than Fugue . Our designer worked 3.5 hours a day, 5 days per week, for 4 consecutive years. As at the manufactory. Using specially crafted for our set generator Corvo from Berezin Artyom, woven two carpet, put through photoshop and get lep

A few weeks ago the project "Nepotism" was three years old that, in my opinion, is quite serious "age." Non-profit project that operates solely on the enthusiasm and which do not help financially nor investors, nor the like-minded, relatively easy to live longer than a year, so it's safe to say at least a single fact: the project is definitely in demand. This publication is not only an attempt to PR (for the sake of cleanliness of experiment, all previous publications and more two-year-old moved to the drafts), but an attempt to share with the participants Habra experience in the development and support of non-profit project to publish typical and atypical mistakes, to talk about how we cope with them and how do not. Due to the fact that the size of the text exceeds the reasonable limits, the publication will be divided at least into two parts: in the first part I will talk about how the project was created as evolved, as developed; in the second p

Two years ago I published an article on habrahabr "ready... set... up! Hi-tech in Israel: industry start-UPS" . Since then much water has flowed, but the main thesis remains relevant to this day: Israel has a lot to learn. This time we offer to meet with Israel not only in words but in deeds. Project Start-Up Nation (based on the bestseller ) invites free to visit Israel as part of a tour of the key places of Israeli industry innovation. A nice bonus: at the end of the tour, the participants will be able to personally present their project (if any) a group of Israeli and international investors. So: 3-14 September 2012, Israel will be visited by a team of specialists in various fields of industry innovations: information technology, biotechnology, business management and innovation management etc. They will be able to look behind the scenes of the Israeli startups in the world through the eyes of the authors of the legendary book "Start-Up Nation".

In the Studio "Finam FM" — Vitaly Myshlyaev, CEO of "the power of the mind", Denis Davydov, Executive Director of the League of safe Internet. Together with the lead, Maxim Spiridonov, they speak about the appointment of the new head of the Corporation Yahoo! claims of Roskomnadzor to LiveJournal and YouTube, about the curious study, which concerns the effectiveness of advertising in Facebook and also about the scandal surrounding the social network “Vkontakte”. / > 1. The new head of the Corporation "Yahoo!" will be Marissa Mayer. — What will become of the Corporation under the new leadership? — Over there now mess with the heads of the company? 2. Roskomnadzor demanded from several Internet resources, which includes blogplatform LiveJournal and video hosting YouTube, to stop the illegal distribution of personal data of Russians. In Runet continue to "tighten the screws"? — Comment: the head of LiveJournal Russia I

23 June, I wrote in "I PR" article of the unexpected brainchild of a small group of programmers — another alternative quotations . A month has passed and it is already possible to draw some conclusions, which I think will be quite useful for those who want to sell themselves through Habr and interesting to those who is going to do sometime PR. Expectations and reality The main stream of visitors went, of course, the day of lent — 23rd. The following day visitors were already a lot less, and after 4 days the flow of new visitors with Habra practically disappeared. With Habra it's only about 3,000 visitors, of which there periodically to visit the resource about 150, i.e., only 5%. Of them registered on the site — 46 people, with 8 people via Facebook, 10 via Google, 2 facebook, 2 twitter, 2 you yandex. The remaining 22 were registered in the usual way. that is, more than 50% of registered users made it through OAuth. Which once again underlines the importance o

hi guys! I hasten to share the good news: we have opened a classy place, namely the coworking "workstation" in Gorky Park. Workstation — this is not our first variation on the theme of coworking. And, it seems, now we have managed to create the space, which we had long dreamed of. From my own experience, we know how important it is for a small but strong teams and fans to work alone, but at the same time tired of the talks in a noisy coffee shops and soporific rustle of pages in the libraries budget to work in a calm, comfortable, creative atmosphere. We wanted to do so, as it happens in Western Kevorkian – to create a professional environment where people could meet and do joint projects. Now we sit IT startups, designers, programmers, and just those who come to surf the Internet on the Ottoman. "Workstation" is located in a quiet part of the Neskuchny Garden, where there are old trees and squirrels running around. Choosing a place in

When bitcoin started to be traded on exchanges and are freely exchanged for Fiat currency, like mushrooms after a rain began to appear cryptocurrency startups. Appeared buzzword "FINTECH" and a scattering of altcoins. Following the trend of smart contracts, the service deals with different types of property. But in the pursuit of money we have forgotten about the true values − justice, law and order, security. But the blockchain allows us to make a breakthrough in these areas! Read below how you can make the world better with the help of a real kriptopolis , and meet the new project in this area. the Four pillars of the rule of law Any law-enforcement system that ensures public safety and enforce laws is held by: 1) openness and transparency; 2) engagement with the community; 3) competitive system in the court; 4) compliance with the rules. Let's look at how we can strengthen these pillars by using the blockchain. Openness and transparency