Explain Codes LogoExplain Codes Logo

Best Articles — Page 399

Why is SELECT * considered harmful?

sql
best-practices
performance
database-design

How do I delete items from a dictionary while iterating over it?

python
dictionary
comprehension
best-practices

Canvas width and height in HTML5

html
responsive-design
canvas
javascript

How do I get a platform-dependent new line character?

java
string-formatting
best-practices
platform-dependency

Create list of single item repeated N times

python
list-comprehensions
performance-testing
memory-optimization

Send POST data using XMLHttpRequest

javascript
xmlhttprequest
post-requests
javascript-requests

Convert Python dict into a dataframe

python
dataframe
pandas
data-orientation

Highlight a word with jQuery

javascript
prompt-engineering
functions
callbacks

Get the difference between 2 dates in JavaScript?

javascript
date-calculations
javascript-date
utc-normalization

How to efficiently remove all null elements from a ArrayList or String Array?

java
collections
best-practices
performance

What is the difference between single and double quotes in SQL?

sql
best-practices
sql-standards
database-objects

How to use multiple WITH statements in one PostgreSQL query?

sql
join
ctes
performance

Create PostgreSQL ROLE (user) if it doesn't exist

sql
database-management
postgresql
role-management

How to get the top 10 values in PostgreSQL?

sql
performance
best-practices
sql-optimization

Npm install cannot find module 'semver'

javascript
npm-install
nodejs-reinstallation
package-management

How do you get centered content using Twitter Bootstrap?

html
responsive-design
flexbox
centering

Partition Function COUNT() OVER possible using DISTINCT

sql
prompt-engineering
join
subqueries

Type safety: Unchecked cast

java
type-safety
unchecked-cast
generics

How to modify the fill color of an SVG image when being served as background image?

css
css-masks
css-filters
svg-color-modification

Java Round up Any Number

java
typecasting
precision
math-ceil