HNHacker News
TopNewBestAskShowJobs

zv

105 karma · joined August 18, 2009

submissionscomments
zv··on Ask HN: How do you manage direct updates to databases in a production system
Gated automated deployment (for MSSQL - dacpac via Azure DevOps, similar things exist for other DBs). Usually can be pre-tested if prod db copy is restored on lower environments. If anything, rollback can be made to previous deployment.

Either way, you need to designate someone who is knowledgeable to oversee the process. Automated deployment just makes this process way faster (thus "reducing bottleneck") where this person only needs to review code to see if anything suspicious isn't there and approve the deployment.

Manual deployments are prone to human error, especially under stress/time pressure. If manual deployment "package" (a set of sql scripts) is poorly written, there's huge incentive to "contact directly", which again could lead to manual errors.

The biggest drawback is culture which is the hardest ("we done this way for n years and we don't want to change").

zv··on The Distribution of Users’ Computer Skills: Worse Than You Think (2016)
So 2 tier applications?
zv··on Google Earth for live radios
I would like to ask if there are any updates for radio addresses. Right now Barrow, AK cannot be connected. It was interesting for me to listen the news they have at corner of earth. Thanks and keep up the good work.
zv··on An AI Lie Detector Is Going to Start Questioning Travelers in the EU
Yes
zv··on Actuarial science ranked as most valuable college major
Look at something like Tower Watson. I would say high barrier of entry.
zv··on You probably don't need AI/ML. You can make do with well written SQL scripts
Sorry, I disagree with you. Let's take forecasting. This is a _very_ hard topic and being applied correctly using actuarial methods it will beat ML. To give you some example, you cannot take sales data for IPhone X and predict its future sales. Reason is simple - market will change, IPhone 11 will come out cannibalizing IPhone X sales. So, you need to have 2 more variables into play. One is the lifetime of a product (approximated) and second is, you need to "put in one basket" several products. Having this, you can predict your sales for some specific product group, no magic ML needed. However this requires you to define "similar products". This is hard because currently it is done semi-automatically using human labor. In fact ML is actually the best one to automagically categorize products into groups, however I have not seen any implementations. To summarize, ML do has value, however not where everybody is pointing out.
zv··on Ask HN: Raw SQL vs. ORM?
Raw SQL queries will perform fast if you write correctly. No ORM will stand close. Stored procedures help a lot. It's close to C/C++ in a sense that is easy to shoot yourself in the foot.

On other hand, ORM helps to write code that can be unit tested and you can test that some data retrieval conforms to certain principles.

zv··on Ask HN: Why isn't literally every train automated?
There was a thread about it on reddit, please go and find it. The trains do not need LIDAR or image recognition. Going in straight line on rails is simple. You don't need to even brake (useless, stopping distance is way too big). What happens in stations and what preparations are done, that cannot (e.g. cost efficiently) be automated. Metro on other hand is mostly automated (see Europe)
zv··on Ask HN: What tech stack is in demand, and why?
My impression so far is that TSQL, SSIS and .Net keeps world running. Frontend Angular/Bootstrap, but again frontend is not that important.
zv··on Ask HN: What problems does blockchain solve?
Let's take first example. As a bank - why it is in your interest to release that authority to blockchain when you are authority and existing infrastructure exists?
zv··on Collecting huge amounts of data with WhatsApp
What's more. If you see their profile pic, you can image search google to check if that picture matches some social networks. Now you have phone->name identification.
zv··on So you wanna be a developer,huh?
Typescript is going to grow. Just sayin...
zv··on Uber's 'hustle-oriented' culture becomes a black mark on employees' résumés
One little secret of retail/sales industry is that everyone knows that best salespeople are pathological liars. So I really doubt that they will be out of job, being con artist is just a plus.
zv··on Dot Watch – A braille and tactile smartwatch
Sorry, this content is not available in your country
zv··on Show HN: Improved passive TCP/IP geolocation
Idea is good however needs more refinement. Currently it detects way wrong at least for me (Europe)
zv··on Polaris: Faster Page Loads Using Fine-grained Dependency Tracking [pdf]
tl;dr anyone? For me - what is seems it tries to automagically optimize poorly written webpages.
zv··on Google says self-driving car hits municipal bus in minor crash
At least in my country, buses have legal right of way when they are driving out of bus stop.
zv··on Show HN: Get the real best price for your hotel or get a superior hotel
Your product targets other type of customer, but I want to share my chores I experienced. Supposedly I plan a trip across USA, by car, for example NY->LA. I don't have exact places at what date I will be at which city. I can approximate 600km-900km drive a day. If there would be application that showed the best hotel on path with driving instructions+reservation it would be godsent.
zv··on How to calculate Ecommerce leakage
We're really sorry, but an error occurred when trying to load the available profiles in your GA account
zv··on Ask HN: What is the state of the art set of tools for front end Web developers?
I want to ask where ember.js stand at?
zv··on “Warning: Do Not use my mirrors/services until I have reviewed the situation”
How about disabling GPM?
zv··on How to buy a tank: a BRDM-2 story
By declaring it as tractor.
zv··on Hackers use weak passwords
Hackers use strong passwords on things they want to protect. No need for strong password on some public site with unimportant data. Even more if those third party sites get compromised, your main security focus is not compromised.
zv··on Show HN: I found a way to 'cheat'/solve 2048 (With live demo)
What if you change the direction? Move right, move down is focusing bottom right corner. How about switching with interval between corners?
zv··on Everything You Know About Fitness Is a Lie (2010)
6 pages. Really. In age of tl;dr it is madness.
zv··on Startup Design Framework
PowerPoint Web2.0?
zv··on Gmail blows up e-mail marketing by caching all images on Google servers
Who said that you have to submit link to your server? Just force it to load large images from other servers. Well you can use help from Google search.
zv··on In Latvia, young people discover new passions in bad economic times
Basically advertisment to http://riga.techhub.com/
zv··on Medium Maker
Absolutely brilliant.
zv··on JsPDF - HTML5 PDF generator
The advantages for PDF is printing. You can't just set correctly page margins and other things with plain HTML.
Page 1 of 3Next →