20 links collected from stackoverflow.com between 2010 and 2021

What is the best comment in source code you have ever encountered?

What is wrong with Cursors?

SQL Server developers consider Cursors a bad practise , except under some circumstances. They believe that Cursors do not use the SQL engine optimally since it is a procedural construct and defeats the Set based concept of RDBMS. However, Oracle developers do not seem to recommend against Cursors. Oracle’s DML statements themselves are implicit cursors. Why this difference in approach ? Is it because of the way these 2 products are made , or does this advise apply to both products ?

Is there a way to access private plsql procedures for testing purposes?

Some of the procedures/functions I like to test aren’t in the package spec and I have no means to change that. Is there a way to access these ‘private’ plsql procedures without adding them to the spec?

oracle10g - Why are Oracle table/column/index names limited to 30 characters?

Apparently the answer is that it will break currently scripts that aren’t defensively coded. I say that is a very worrying thing, Oracle is trying to be the database, surely this is the kind of thing that you must constantly improve, otherwise your product will die the death of a thousand cuts.

Should I use Vagrant or Docker.io for creating an isolated environment?

In conclusion: in highly specific use cases, Docker is certainly a possible replacement for Vagrant. In most use cases, it is not.

Can I make a <button> not submit a form?

The default value for the type attribute of button elements is "submit".

Colors in JavaScript console

In Chrome & Firefox (with Firebug 11.2 ) you can add CSS in console.log messages: console.log(’%c Oh my heavens! ’, ‘background: #222; color: #bada55’);

flex - How can I pass the string "Null" through WSDL (SOAP) from ActionScript 3 to a ColdFusion web service without receiving a "missing parameter error"? - Stack Overflow

We have an employee whose last name is Null. He kills our employee lookup application when his last name is used as the search term (which happens to be quite often now).

Secure hash and salt for PHP passwords

I want to know which hashing function(s) to use and how to pick a good salt in order to have a safe and fast password protection mechanism.

synchronization - Symbolic links and synced folders in Vagrant - Stack Overflow

Virtualbox does not allow symlinks on shared folders for security reasons. To enable symlinks the following line needs to be added to the vm provider config block in the Vagrantfile:

css - Why use XSL-FO instead of CSS2, for transform HTML into good PDF? - Stack Overflow

If you go further and implement a new system for XML-Publishing, there are no good reason to use XSL-FO.

How to make empty div one line height using CSS? - Stack Overflow

select div:empty::before instead if you choose to use a pseudo-element so the filler doesn’t get inserted if there is content.

How to create a fluent query interface?

It’s not difficult to realize that in order to achieve this the methods being chained must incrementally set up some data structure which is finally being interpreted by some method that executes the final query. But there are some degrees of freedom regarding exactly how this can be orchestrated.

Show Icon in Safari Pinned Tabs

You can set the icon that the user sees when they pin your site by providing a vector image. Use 100% black for all vectors with a transparent background in SVG format and add the following markup to all webpages that the icon should represent (replacing "website_icon" with your own file’s name).

javascript - HTML canvas - drawing disappear on resizing - Stack Overflow

setting the width or height of a canvas, even if you are setting it to the same value as before, not only clears the canvas but resets the entire canvas context.

angularjs - How do I debug/dump a value from an ng-bind {{ }} Angular expression?

I’ve been using React a lot lately. Seeing that I need to add custom code to debug janky fake JS forced into HTML makes me sad.

The difference between call and apply

A useful mnemonic is "A for array and C for comma."

Why does Object.assign() require a polyfill when babel-loader is being used?

Babel, via babel-loader, transpiles differences in ES6 syntax. Babel on its own does absolutely nothing to add in ES6 standard library functionality (like Object.assign).

nil?/empty?/blank?/present? in Ruby on Rails

I made this useful table with all the cases

Architecture for search engine based on distributed key/value store?

Is anyone aware of any links, papers, presentations, or blog posts that describe a large-scale full-text search engine built upon a distributed key/value store?