learning sqlite

create table named t3 (id, value). id is integer. value is text sqlite> create table if not exists t3( id int , value varchar, primary key(id)); adding two “rows” sqlite> insert into t3 (id, value) values (1, 'a'); sqlite> insert into t3 (id, value) values (2, 'b'); display results sqlite> select *  from t3; 1|a 2|b update id=1 if exists, insert otherwise (id=1 exists) sqlite> insert or replace into t3 (id,value) values (1,‘c’ ); sqlite> select * from t3; 2|b 1|c...

February 9, 2014 · SergeM

remote desktop screen resolution

Today I finally found out that screen resolution for remote session in Windows can be changed in settings menu before connection. Little discoveries happen every day… Damn….

February 5, 2014 · SergeM

Multithreading links

Руководство по отладке многопоточных приложений в Visual Studio 2010. video, exampleshttp://habrahabr.ru/post/97817/ Считаем Пи параллельно. Часть 1. pthread, openmp, c++11 in commentshttp://habrahabr.ru/post/147796/ Потоки, блокировки и условные переменные в C++11 [Часть 1], exceptions, exampleshttp://habrahabr.ru/post/182610/ Потоки, блокировки и условные переменные в C++11 [Часть 2][http://habrahabr.ru/post/182626/](http://habrahabr.ru/post/182626/)

February 3, 2014 · SergeM

VapourSynth: pythonic alternative to avisynth

What do I know about VapourSynth http://www.vapoursynth.com/ - website How to save data from VapourSynthYou need to use vspipe.exe from Vapour distributiveIt seems it returns raw data to stdout Render using ffmpegDon't know how jet Render using ImageMagick/convertDon't know how jet Image ReadingImage reading causes crash of AvsPmod, in which I using Vapoursynth[http://forum.doom9.org/showthread.php?t=166088](http://forum.doom9.org/showthread.php?t=166088)src: [https://github.com/chikuzen/vsimagereader](https://github.com/chikuzen/vsimagereader" target="_blank) Other AvsPmod - new version of AvsP. AvsP is a tabbed avs editor with convenient results preview....

January 25, 2014 · SergeM

Tables in Latex. Multiline, right alignment

I used _tabularx _package. Additional definitions: \usepackage{array} \newcolumntype{L}{>{\raggedright\arraybackslash}X} % left multiline alignment \newcolumntype{R}{>{\raggedleft\arraybackslash}X} % right multiline alignment Table: \begin{tabularx}{\textwidth}{@{}p{0.8\linewidth} R} Text, aligned to the left, without margin \newline Tex in the same cell on the next line & % next column delimiter Text aligned to the right \newline second line \end{tabularx} Here we have one columt with 80% width and one column with right alignment @{} is required to suppress left margin in the first column....

January 23, 2014 · SergeM

How?

How does start menu in Win7 select the most useless new application i’ve installed?

January 17, 2014 · SergeM

Building ConEmu

Problems with ConEmu building from https://github.com/Maximus5/ConEmu.git v14.01.06in Visual Studio 2010ConEmuCunresolved external symbol `__imp__`wsprintfA - add additional dependency **User32.lib** **ConEmuCD**Error 3 error LNK2001: unresolved external symbol `__imp__`CharUpperBuffW@8 Error 4 error LNK2001: unresolved external symbol `__imp__`MapVirtualKeyW@8 Error 5 error LNK2001: unresolved external symbol `__imp__`VkKeyScanW@4 Error 6 error LNK2001: unresolved external symbol `__imp__`GetSystemMetrics@4 Error 7 error LNK2001: unresolved external symbol `__imp__`IsRectEmpty@4 Error 8 error LNK2001: unresolved external symbol `__imp__`MonitorFromRect@8 Error 9 error LNK2001: unresolved external symbol `__imp__`GetMonitorInfoW@8 Error 10 error LNK2001: unresolved external symbol `__imp__`MonitorFromWindow@8 Error 11 error LNK2001: unresolved external symbol `__imp__`SystemParametersInfoW@16 etc....

January 16, 2014 · SergeM

Free software for screen video capture

CamStudio 2.7 http://camstudio.org/ works fine Rylstim-Screen-Recorder http://www.sketchman-studio.com/rylstim-screen-recorder/ There were some troubles while recording ConEmu software Portable version is available HyperCam 2 http://www.hyperionics.com/hc/ Works well

January 15, 2014 · SergeM

Temporary files format that can be deleted from project of Visual Studio 2010

Add to .gitignore: *.ipch Debug Release *.sdf - The SDF file is your code browsing database which uses SQL Sever Compact Edition. You don’t need to copy this SDF file while you move your project, and it will be automatically populated in the new location once you open your project. [[1](http://social.msdn.microsoft.com/Forums/en-US/20fee924-e267-4c1a-b0fe-3321f86e1bb5/sdf-file?forum=vcprerelease" target="_blank)] [[2](http://social.msdn.microsoft.com/Forums/vstudio/en-US/1ef46540-e4b8-4779-8403-49239bc3f7ee/is-it-safe-to-delete-ipch-folder-precompiled-headers?forum=vcgeneral" target="_blank)]

January 14, 2014 · SergeM

Migrating from SVN to Git and Mercurial

There is a lot of answers here: http://stackoverflow.com/questions/79165/how-to-migrate-svn-with-history-to-a-new-git-repository I found rather useful [this one](http://stackoverflow.com/a/9316931" target="_blank). A guy made a script according to proposed instructions: https://github.com/onepremise/SGMS This script will convert projects stored in SVN with the following format: /trunk /Project1 /Project2 /branches /Project1 /Project2 /tags /Project1 /Project2 This scheme is also popular and supported as well: /Project1 /trunk /branches /tags /Project2 /trunk /branches /tags Each project will get synchronized over by project name:...

January 8, 2014 · SergeM