Entwicklung Archives - Page 5 of 13

Golang get openid-connect userinfo

7. July 2022 | 3 min read

It might not be news to you, but this will explain a little bit about Go, making http requests and parsing the result. OpenID-Connect (oidc) is an identity protocol, you could call it an Oauth2 dialect. It manages your users per realm, well not the protocol but the server does. Every oidc idp (identity provider…

Read Article

False Alarm: Serious Bug in MongoDB Go Driver’s Geospatial distance calculation

19. May 2022 | 5 min read

Final Edit: False Alarm It’s not MongoDB, It’s not the MongoDB Go driver, it’s something I did. I was especially careful to double and triple check Long and Lat and still something went wrong.

Read Article

The stupidity and ambiguitiy of Vue

1. April 2022 | 1 min read

Rant mode: Which idiots name template references “ref” and then name essentially all composition api variables “ref()” as well!?! YEAH GOOD FUCKING JOB VUE DEVELOPER IDIOTS It makes searching for answer so much more fucking frustrating! Fucking idiots.

Read Article

Spring Data JPA fixtures

14. March 2022 | 1 min read

What are fixtures? Fixed data that is always present in the database. You can think of it as the initial dataset. application.properties

spring.jpa.hibernate.ddl-auto=create
spring.jpa.generate-ddl=true
spring.jpa.open-in-view=false
spring.sql.init.mode=always
spring.sql.init.data-locations=classpath:db/data.sql
spring.jpa.defer-datasource-initialization=true

1

2

3

4

5

6

spring.jpa.hibernate.ddl-auto=create

spring.jpa.generate-ddl=true

spring.jpa.open-in-view=false

spring.sql.init.mode=always

spring.sql.init.data-locations=classpath:db/data.sql

spring.jpa.defer-datasource-initialization=true

The documentation speaks of “the root classpath”, not knowing Java well I had no idea what that means and an answer on Stackoverflow was of course wrong. It’s not the “src” dir,…

Read Article

Spring Data JPA Postgres UUID @Id

14. March 2022 | 1 min read

I read lots of outdated info on this matter. Using PostgreSQL v13+ there is a function called gen_random_uuid(). See the manual page of Postgres UUID. Here’s an example entity called Page

package de.icod.blog.model;

import javax.persistence.*;
import java.util.UUID;

@Entity
@Table(name = "page")
public class Page {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name = "id", nullable = false, columnDefinition = "UUID default gen_random_uuid()")
    private UUID id;

    public UUID getId() {
        return id;
    }

    public void setId(UUID id) {
        this.id = id;
    }
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

package de.icod.blog.model;

import javax.persistence.*;

import java.util.UUID;

@Entity

@Table(name = "page")

public class Page {

@Id

@GeneratedValue(strategy = GenerationType.AUTO)

@Column(name = "id", nullable = false, columnDefinition = "UUID default gen_random_uuid()")

private UUID id;

public UUID getId() {

return id;

}

public void setId(UUID id) {

this.id = id;

}

As you see you can append the columnDefinition to the @Column annotation. “UUID default gen_random_uuid()” This translates to following SQL

create table page
(
    id uuid default gen_random_uuid() not null
        constraint "primary"
            primary key
);

1

2

3

4

5

6

create table page

(

id uuid default gen_random_uuid() not null

constraint "primary"

primary key

);

And you…

Read Article