Web Development Business

SQL for Application Developers

Mark Adelsberger Articles, Databases, Development Technologies & Tools, Programming, SQL 3 Comments

Attention: The following article was published over 9 years ago, and the information provided may be aged or outdated. Please keep that in mind as you read the post.“SQL? Isn’t that just something my ORM tools use?” Often application developers can and should remain at least one level removed from SQL. JPA and the Entity Framework each provide more abstract …

What’s up with WITH?

Scott Peters Articles, Databases, Development Technologies & Tools, Python 1 Comment

Attention: The following article was published over 12 years ago, and the information provided may be aged or outdated. Please keep that in mind as you read the post.Ah, the WITH statement. A (mostly) loved holdover from such languages as Python and VB(A) that still finds some questionable use today in JavaScript. It was easy to use and could save …

Mapping Shortest Routes Using a Graph Database

Lou Mauget Articles, Databases, Development Technologies & Tools, Java 11 Comments

Attention: The following article was published over 12 years ago, and the information provided may be aged or outdated. Please keep that in mind as you read the post.We often model interconnected data by cramming it in and out of table structures. Why don’t we simply model interconnected data as … interconnected data? I recently wrote that there are several …

Is NoSQL The SQL Sequel?

Lou Mauget Articles, Databases, Development Technologies & Tools, Opinion, SQL 8 Comments

Attention: The following article was published over 13 years ago, and the information provided may be aged or outdated. Please keep that in mind as you read the post.“Can’t we all just get along?”  I assert that the explosion of so-called NoSQL database management systems (DBMS) is not displacing the well-known relational DBMS (RDBMS) that we love and admire. There …