Explain Codes LogoExplain Codes Logo

Best Articles — Page 232

Is there common street addresses database design for all addresses of the world?

sql
database-design
geocoding
data-normalization

Postgresql Index Usage Analysis

sql
database-performance
index-optimization
postgresql

Why are data transfer objects (DTOs) an anti-pattern?

java
best-practices
design-patterns
object-oriented-programming

Check for changes to an SQL Server table?

sql
checksums
change-detection
sql-server

How to make an ng-click event conditional?

javascript
prompt-engineering
best-practices
usability

Unable to obtain LocalDateTime from TemporalAccessor when parsing LocalDateTime (Java 8)

java
datetime
localdatetime
date-formatting

How do I convert Long to byte[] and back in Java

java
endianness
bitwise-operations
performance-benchmarking

How to get current instance name from T-SQL

sql
server-properties
sql-server
database-management

Constructor in an Interface?

java
singleton
design-patterns
inheritance

Do I really need to encode '&' as '&'?

html
html-encoding
security-best-practices
html-validation

Highlight label if checkbox is checked

html
responsive-design
accessibility
css

React - changing an uncontrolled input

javascript
controlled-inputs
react-components
state-management

Where statement after a UNION in SQL?

sql
sql-performance
best-practices
query-optimization

Render HTML to PDF in Django site

python
pdf-generation
django-templates
html-rendering

Using a Single Row configuration table in SQL Server database. Bad idea?

sql
best-practices
schema-design
database-optimization

Getting the exception value in Python

python
exception-handling
debugging
logging

What is Ad Hoc Query?

sql
ad-hoc-queries
sql-performance
database-optimization

How do you create a temporary table in an Oracle database?

sql
database-design
performance-optimization
sql-queries

How to write a WHERE Clause to find all records in a specific month?

sql
join
best-practices
performance

Checking for a null int value from a Java ResultSet

java
null-handling
resultset
ternary-operator