Tutorial by Examples: d

(function(){ var hashMap = {}; function isAnagram (str1, str2) { if(str1.length !== str2.length){ return false; } // Create hash map of str1 character and increase value one (+1). createStr1HashMap(str1); /...

Solves problem of: access denied for user root using password YES Stop mySQL: sudo systemctl stop mysql Restart mySQL, skipping grant tables: sudo mysqld_safe --skip-grant-tables Login: mysql -u root In SQL shell, look if users exist: select User, password,plugin FROM mysql.user ; U...

Getting started with xUnit.net, on Platform: .NET Core / ASP.NET Core Desktop CLR Universal Windows Apps

display dialog "Password" default answer "" set w to text returned of the result if w = "Password" then display notification "Correct" end if

CREATE INDEX ord_customer_ix ON orders (customer_id); By default, if we do not mention anything, oracle creates an index as a b-tree index. But we should know when to use it. B-tree index stores data as binary tree format. As we know that, index is a schema object which stores some sort of entry...

CREATE BITMAP INDEX emp_bitmap_idx ON index_demo (gender); Bitmap index is used when data cardinality is low. Here, Gender has value with low cardinality. Values are may be Male, Female & others. So, if we create a binary tree for this 3 values while searching it will have unnecessary ...

CREATE INDEX first_name_idx ON user_data (UPPER(first_name)); SELECT * FROM user_data WHERE UPPER(first_name) = 'JOHN2'; Function based index means, creating index based on a function. If in search (where clause), frequently any function is used, it's better to create index based on ...

NERD TREE is a plugin by scrooloose that allows you to explore the file system while using vim. You can open files and directories via a tree system that you can manipulate with the keyboard or the mouse. Add this to your .vimrc to start NERDTree automatically when vim starts up: autocmd vimenter...

var MongoClient = require('mongodb').MongoClient; //connection with mongoDB MongoClient.connect("mongodb://localhost:27017/MyDb", function (err, db) { //check the connection if(err){ console.log("connection failed."); }else{ ...

The NamedParameterJdbcTemplate class adds support for programming JDBC statements using named parameters, as opposed to programming JDBC statements using only classic placeholder ( '?') arguments. The NamedParameterJdbcTemplate class wraps a JdbcTemplate, and delegates to the wrapped JdbcTempl...

Angular 4 is now available! Actually Angular uses semver since Angular 2, which requires the major number being increased when breaking changes were introduced. The Angular team postponed features that cause breaking changes, which will be released with Angular 4. Angular 3 was skipped to be able to...

Suppose you need to work on three different projects project A, project B and project C. project A and project B need python 3 and some required libraries. But for project C you need python 2.7 and dependent libraries. So best practice for this is to separate those project environments. For creati...

In order to chain asynchronous operations and avoid a callback hell, Vala supports the yield statement. Used with an asynchronous invocation, it will pause the current coroutine until the call is completed and extract the result. Used alone, yield pause the current coroutine until it's being woken...

class ConversationsTableViewController: UITableViewController, NSFetchedResultsControllerDelegate { private var fetchedResultsController: NSFetchedResultsController<Conversation>! override func viewDidLoad() { super.viewDidLoad() initializeFetchedResultsController() } private...

Supervised learning is a type of machine learning algorithm that uses a known data-set (called the training data-set) to make predictions. Category of supervised learning: Regression: In a regression problem, we are trying to predict results within a continuous output, meaning that we are trying...

Unsupervised learning allows us to approach problems with little or no idea what our results should look like. We can derive structure from data where we don't necessarily know the effect of the variables. Example: Clustering: Is used for exploratory data analysis to find hidden patterns or groupi...

To get started, create a new Maven webapp (how to do this is outside the scope of this example). In your pom.xml, add the following two dependencies <dependency> <groupId>org.glassfish.jersey.containers</groupId> <artifactId>jersey-container-servlet</artifactId&...

If you want to use a podfile in more than one target, you can do like this. You can choose the download address when you pod this lib. def testpods pod 'YSDPush', :git => 'https://github.com/youshaoduo/YSDPush.git' end target 'One' do testpods end target 'Two' do testpods ...

Calendar : Key : Privacy - Calendars Usage Description Value : $(PRODUCT_NAME) calendar events Reminder : Key : Privacy - Reminders Usage Description Value : $(PRODUCT_NAME) reminder use Contact : Key : Privacy - Contacts Usage Description Value : $(PRODUCT_...

To list the available databases, use the following command: $ show databases name: databases name ---- _internal devices ... list of your databases You can connect to one specific database: $ use <database_name> By using a single database, the scope for each subsequent query wi...