The Latest

Concatenate Strings in a List

Use the join operator to concatenate strings in a list. str = [“devx”, “is”, “for”, “developers”] str = (” “.join(str)) Related Posts AI entrepreneur raises $13.8 million via LinkedInPayments Made

How to Selectively Expose CRUD Operations

In order to selectively expose CRUD operations, we need to define an intermediate interface, annotated as below: @NoRepositoryBeaninterface IntermediateRepository extends Repository { // add here the selected CRUD, for example

Types of Engines that Are Supported in MySQL

MySQL supports multiple types of storage engines. There are specific engines that are meant for specific needs. Understanding of these storage engines is beyond the scope of the current discussion.

How to Define a SynchronousQueue in Java

For defining a SynchronousQueue in Java, we need the BlockingQueue interface as follows: BlockingQueue queue = new SynchronousQueue(); Related Posts Tip: The sp_rename SQL Stored ProcedureInteresting Java.lang.Math ClassCocaine Smuggler Caught:

Working with Multiple Query Windows

Working with and comparing multiple queries at the same time can be a pain, at least for me. Two independent query windows take up more space on screen, or having

Get the Size of an Object in Python

Use getsizeof method to retrieve the size of an object in bytes. See below for an example: str = “devx” print(sys.getsizeof(str)) Related Posts Stanford Project Measures Nature’s ValueSmartwatch Sales Plummet

Finding the TAN of a Given Number

MySQL provides numerous mathematical calculations that can be computed with inbuilt functions. In order to find the TAN of a number, we can use the following: Query: SELECT TAN(400); Sample

How to Convert a List into a Set and Vice Versa

Converting List to Set: List list = Arrays.asList(1, 2, 3);Set set = new HashSet(list); Converting Set to List: Set set = Sets.newHashSet(1, 2, 3);List list = new ArrayList(set); Related Posts

How to Quickly Sort an Array

The quickest solution for sorting an array in Java relies on Arrays.sort() method as below: int[] arr = {5, 12, 3, 44, 55}; Arrays.sort(arr); Related Posts AI reshapes cloud infrastructure

Allow Only One Null Property

Consider a Review object with three properties: article, book and magazine. Let’s assume that only one of these three properties should be set as non-null. For checking this constraint we

Using the SUBSTRING_INDEX in MySQL

The SUBSTRING_INDEX helps in extracting a part of the given string from the beginning to the match in the index. Query: SELECT SUBSTRING_INDEX(‘MySQL Database’, ‘a’, 2) AS SUBSTRING_INDEX; Here, the

How to Declare a Pattern in Java

The best way to declare a Pattern in Java is as a constant, since Pattern is immutable. Use the following code: private static final Pattern PATTERN = Pattern.compile(” +”); Further,

Selecting All Columns, Separated with Commas

Sometimes you want to select all the columns, without using the *. Specifying column names speeds up your query. The problem comes in with large tables or tables with difficult

List the Attributes and Methods of an Object in Python

Use the dir() function to return the list of the attributes and methods of the object. Syntax :dir({object}) Related Posts Musk abruptly withdraws OpenAI lawsuitStumbling reliable member prompts protocol reviewMark

Handling BindException in Java

Port BindExceptions can occur if a port is already occupied by some other process and you try to use it again. Below is a simple example that demonstrates this and

DevX - Software Development Resource

Convert number to string in Python

To convert, e.g., the number 144 to the string ???144???, use the built-in type constructor??str() Related Posts The Fast and the Furious: 8 Tips for Speeding Things UpActivists blame Pakistan for internet slowdownWorld AI Conference opens in ShanghaiTop Software Development Companies in PolandNorwegian Startup

How to Pass Parameters in @Query

Passing parameters to an SQL query written via @Query can be done via @Param or via positional parameters: // via @Param@Query(value = “SELECT p FROM Product p WHERE p.department=:department”)List fetchByDepartment(@Param(“department”)

Object Explorer Details

I hate repetitive tasks. I am not a robot. However, the problem is that there are some tasks that can be quite repetitive or just take too many steps to

Convert a String to a Number in Python

Use the int() type constructor to convert a string to number. Sample code: int(‘208’) == 208 Related Posts IBM Expands OpenStack Cloud ServicesMapR Unveils a Kafka Alternative Called StreamsThe Surprising

Inspect Class Annotations

Class annotations can be inspected via reflection as follows: Class clazz = Foo.class;Annotation[] clazzAnnotations = clazz.getAnnotations(); Related Posts Types of Engines that Are Supported in MySQLBrookfield raises $2.4 billion for

Locking a User Account in MySQL

After a user has been created and is currently in use, a need might arise for the user account to be locked. MySQL provides a mechanism to alter the user

Call a Private Constructor

Calling a private constructor from outside its class can be done via Reflection as follows: public final class Users { private Users() {} // static members}Class usersClass = Users.class;Constructor emptyUsersCnstr

Using Multi Edit Mode

This is a neat trick I have learnt recently. When dealing with large lists of information, we, as developers, sometimes need to copy them, then add commas manually. Say, for

Multithreading in Python

Using ThreadPoolExecutor from the concurrent.futures library, we can spin threads quickly and execute tasks in parallel. Wrap your time consuming method with the thread pool executor.. Without threading: for task

DevX - Software Development Resource

Memory wasted by Spring Boot application

One of the widely wasted resources in the world today is: Memory. Due to inefficient programming, surprising (sometimes ???shocking???) amount of memory is wasted. We see this pattern repeated in several enterprise applications. To prove this case, we conducted a small study. We analyzed the famous spring boot pet clinic application to see how much memory it is wasting. This application has been designed by the community to show how the spring application framework can be used to build simple but powerful database-oriented applications.  Related Posts Yahoo integrates with AOL, enhancing online advertisingTROUBLESHOOTING TIMEOUT IN AWS ELASTIC BEANSTALKSynchronizationContext in C#Apple AirTags hit lowest price on AmazonWriting RESTful Web Services in Python with Flask

Transform a String into IntStream

Returning a stream of int zero-extending the char values from a String can be done via chars(): String str = “hello world”;IntStream chars = str.chars(); Related Posts Deutsche Bank shares

Performing File Compression in Java

Often, file sizes are too big to back them up or share them with someone. You can create a compressed version that will save you disk space, transfer time, etc.

Get All Columns in All Tables of a Specific Data Type

We can get all columns in all tables of a specific data type. The example below gets all INT columns in the entire database SELECT OBJECT_NAME(sys.columns.OBJECT_ID) as TableName, sys.columns.name as