devxlogo

The Latest

Using String.join to Concatenate Strings

String.join is an easy-to-use utility method in String class. public class StringJoin{ public static void main(String args[]){ //The first argument (refered as joinString) is used to join the subsequent argument(s)

Calling Java Methods Using Lambda Expressions

To call Java methods using Lambda expressions you can use: – Car::makeCar //Static method of a class- Car::drive // Method of an instance- Car::new //Constructor of a class- Car::drive //

Restrict the Connection to a Database in SQL

You can restrict the connection to a database by specifying Single User mode, as shown below: USE master;GOALTER DATABASE YourDatabaseNameSET SINGLE_USERWITH ROLLBACK IMMEDIATE;GOALTER DATABASE YourDatabaseNameSET READ_ONLY;GOALTER DATABASE YourDatabaseNameSET MULTI_USER;GO This

Limiting the rows returned – MySQL

Ideally, this is a performance enhancement and needs lot of visibility before hand to implement at early stages. There are numerous cases when you are running on low memory and want to limit the data in your transactions.Especially, when you are sure that you dont need all the records matching your query, you can have criterias set. Stil, there could be plenty of them returned and you may want just a handfull of them or a little more. In MySQL, LIMIT is a feature that helps fetch a certain number of records matching the criteria provided  Eg: SELECT * FROM `database_name`.`table_name` LIMIT 10; The value of LIMIT is defined by what your need is. Use it accordingly to allow only the specified records is returned so that you also benefit with performance and quicker processing. Related Posts Handy Function to Test for Email ValidityDatabricks Adds Deep Learning and GPU Acceleration to SparkForrester: 100% of Enterprises Will Adopt HadoopBBVA’s €11.5 billion

Calculating Availability

Availability is measured in so-called nines notation, that corresponds to the percentage of time that a service is available. For example, if a service is available 99.9% of the time, we can say that has “three-nines availability”. This notation is used to gives us the specific amount of downtime that a service is allowed to have.  Next are the availability and downtime calculations for 99% availability to 99.999% availability : 99% availability (two-nines):         * 3.65 days/year (of allowed downtime)         * 7.20 hours/month         * 1.68 hours/week         * 14.4 minutes/day 99.9% availability (three-nines):         * 8.76 hours/year         * 43.8 minutes/month         * 10.1 minutes/week         * 1.44 minutes/day 99.99% availability (four-nines):          * 52.56 minutes/year        * 4.38 minutes/month        * 1.01 minutes/week        * 8.66 seconds/day 99.999% availability (five-nines):        * 5.26 minutes/year        * 25.9 seconds/month        * 6.05 seconds/week        * 864.3 mimiseconds/day Related Posts Foxe Capital Supports Fintech Startups, Collaborates

Quickly escape the escape characters in a string.

C# provides you a way to escape the problematic characters in a string through the ???@??? symbol. Just place it before the string, and the compiler will escape those characters.For e.g. String filePath = @???c:windowssystem32???;Thus you do not have to escape the slashes in the string in the above example. Related Posts AI Algorithm Explores Cancer Cell NeighborhoodsIGEL adds Cisco VXME to its unified communications portfolioMicrosoft SQL Server Will Support LinuxBitbucket Pipelines Now Generally AvailableTop 10 Test Management Tools

View the Certificate of a Website in Chrome

You can easily access a website’s certificate in Chrome via the developer tools. Go to developer tools (F12), Security tab. In the Security Overview section, choose “view certificate.” Related Posts

Avoid Scrolling for Information

Avoid?Scrolling?in?the?same?document?for?some?information. Using?the windows?”split”?feature?available?in?the?VS.NET IDE?and?you?can?split?the?document?window?into?two?and?have?two?windows?with?the?same?content?aligned?horizontally. You?can?thus?find?the?information?you?were?looking?for?and?avoid?long?scrolls. Related Posts Google’s Container Engine Now Generally AvailableEnterprise Development Insights from the Tim Cook InterviewAPI Design Basics for Micro Service Oriented ArchitecturesBroadband Forum brings Fiber

The sp_spaceused Procedure in SQL

The sp_spaceused special SQL procedure displays the number of rows, disk space reserved, disk space used by a table, or indexed view in the current database. Here is a small

CORS Support in Spring

Spring MVC has implicit CORS support, so to use the controller method CORS configuration with @CrossOrigin annotation in your Spring Boot application does not require any specific configuration. The global

Display of Bit Field on UI

Fields with ‘Bit’ Data Types, when displayed on Web Pages show as True/False. They don’t show the actual ‘0’ / ‘1’. If you are using a DataReader to retrieve such

Creating the Hash for Short URLs

The hashing function is used to generate random strings of six characters, that can be numbers or upper and lowercase letters. We need to make sure that a string is

Merge Two DataTables, Preserving the Old Values

The datatable1.Merge(datatable2) statement will merge datatable2 into datatable1. You cannot retrieve the old values in the datatable1 after the merge happens. A quick way to do that, is by creating

Add a selectedIndex Changed Event Handler to a ComboBox

When you create the datagridview associate an event handler for its ‘EditingControlShowing’ event. sampleDataGridView.EditingControlShowing += new DataGridViewEditingControlShowingEventHandler(DataGridViewEditingControlShowing); And in the event handler add the selectedIndexChanged eventhandler to the combobox. private

Setting a JPA Hint in Spring

How to set a Java Persistence API hint in Spring: @Override@QueryHints(value = { @QueryHint(name = “org.hibernate.cacheable”, value = “true”)})public List findAll(); Related Posts Use SUBSTR to Remove the Last Character

Retrieving Data from a Deleted row in a Dataset

You would get the ‘DeletedRowInaccessibleException‘?when you try to access a deleted row in a dataset. To retrieve the information of a deleted row in a dataset, use the overloaded property

UUID in Java

/*A UUID is a 36 character string, 32 alphanumeric characters and 4 hypens123e4567-e89b-12d3-a456-426655440000Java supports generation and usage of this using the java.util.UUID class*/public class JavaUUID{ public static void main(String args[])