Home » Tag Archives: SQL

Tag Archives: SQL

Golang – The database/sql package

This post is part of a series where I do my best to organize my thoughts around Go: its paradigms and usability as a programming language. I write this as a Java programmer that respects the principles of Elegant Objects. I am studying the Go Code Review mantra Accept Interfaces, Return Structs and was inspired to write this post after ...

Read More »

Coding Skills That Will Elevate Your Digital Marketing Career

Digital marketing platforms are teeming with an ever-increasing array of marketing software that you can use to stay competitive and keep up with the demands of the increasingly tech-savvy users. Today’s digital marketing is largely data-driven, and to have an edge over the competition, you need to use the right software on the various marketing platforms wisely and decisively to ...

Read More »

Fully working prototypes with Spring Boot and H2


We do use a lot of h2 with spring especially for unit tests. However instead of unit tests we might want to have a fully functional prototype with data to display. H2 is the perfect candidate for that, it works great with spring, it has good syntax compatibility with most databases out there and it also provides you with a ...

Read More »

Query Databases Using Java Streams

In this article, you will learn how you can write pure Java applications, that are able to work with data from an existing database, without writing a single line of SQL (or similar languages like HQL) and without spending hours putting everything together. After your application is ready, you will learn how to accelerate latency performance with a factor of ...

Read More »

JPA persistence.xml SQL script definitions


You can define and link to SQL scripts in a JPA persistence context definition that will be executed at runtime. There are standardized properties to define scripts how to create the schema, bulk-load data and drop the schema, respectively: <persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd"> <persistence-unit name="prod" transaction-type="JTA"> <properties> <property name="javax.persistence.schema-generation.database.action" value="drop-and-create"/> <property name="javax.persistence.schema-generation.create-script-source" value="create-schema.sql" /> <property name="javax.persistence.schema-generation.sql-load-script-source" value="load-data.sql" /> ...

Read More »