rponte

Create Repository Gitlab

Creates a new repository (aka project) in a specific Gitlab group.

How to set up this project

This project was developed with Python v3.9, and it also uses Python's Virtualenv tool. So before working on this project we need to set up it.

Inside this project's folder, execute those commands to configure your environment:

rponte

/**
 * This Spring Boot controller was implemented as an example of a simple but robust idempotent REST API that
 * leverages the ACID properties of a relational database.
 */
@RestController
public class CreateNewUserController {

    @Autowired
    private UserRepository repository;
    @Autowired

rponte

package br.com.stackspot.nullbank.withdrawal;

import org.hibernate.LockOptions;
import org.springframework.data.jpa.repository.*;
import org.springframework.stereotype.Repository;

import javax.persistence.LockModeType;
import javax.persistence.QueryHint;
import javax.transaction.Transactional;
import java.util.Optional;

rponte

package br.com.zup.edu.ifoodwebapp.samples.books;

import base.SpringDataJpaIntegrationTest;
import org.junit.jupiter.api.BeforeEach;
import org.junit.jupiter.api.DisplayName;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.dao.DataIntegrityViolationException;
import org.springframework.transaction.TransactionSystemException;

rponte

import javax.persistence.*;
import javax.validation.constraints.NotBlank;
import javax.validation.constraints.Size;

import org.hibernate.validator.constraints.ISBN;

import java.util.Objects;

import static org.hibernate.validator.constraints.ISBN.Type.ISBN_13;

rponte

The issue with SSL certificate

Just out of the blue, I started getting this issue ("server certificate verification failed. CAfile: none CRLfile: none") while trying to clone any Github repository on Linux (WSL2):

git clone https://github.com/rafaelpontezup/preventing-lost-update-racecondition.git
Cloning into 'preventing-lost-update-racecondition'...
fatal: unable to access 'https://github.com/rafaelpontezup/preventing-lost-update-racecondition.git/': server certificate verification failed. CAfile: none CRLfile: none

And also with Window 11 I got "SSL certificate problem: unable to get local issuer certificate":

rponte

• Distributed Polling with SKIP LOCKED
  1. https://www.evernote.com/client/web#?an=true&fs=true&n=93f6cdf2-633d-4051-8b99-7e2d05498ead&s=s173&
  2. https://gist.github.com/rponte/0c5b0e3c1b84c0c2e49c863215c2c0f4
  3. https://gist.github.com/rponte/5e8d41fd3b2ced22206dce788208c30b (Implementing, rewriting, and rebuilding a task queue - by @tef_ebooks)
  4. https://todd-hubers.medium.com/you-really-can-replace-kafka-with-a-database-9e82a7c248a6 (Replacing Kafka with a database?)
  5. https://www.cloudamqp.com/blog/2015-11-23-why-is-a-database-not-the-right-tool-for-a-queue-based-system.html
  6. https://viralpatel.net/blogs/oracle-skip-locked/
  7. https://vladmihalcea.com/database-job-queue-skip-locked/
  8. https://github.com/vladmihalcea/high-performance-java-persistence/blob/master/core/src/test/java/com/vladmihalcea/book/hpjp/hibernate/concurrency/SkipLockJobQueueTest.java#L186
  9. https://docs.jboss.org/hibernate/orm/5.2/userguide/html_single/Hibernate_User_Guide.html#locking-follow-on

rponte

DROP TABLE customers, invoices, items;

CREATE TABLE customers (
    customer_id SERIAL PRIMARY KEY,
    name TEXT NOT NULL UNIQUE
    );

CREATE TABLE invoices (
    invoice_id SERIAL PRIMARY KEY,
    customer_id BIGINT REFERENCES customers (customer_id)

rponte

Scale breaks hardware. Speed breaks software. Speed at Scale breaks everything. -- via @adrianco & @jedberg

@adrianco: "Scale breaks hardware; speed breaks software; Speed At Scale breaks everything" (haha) #flowcon

Netflix: SPEED at SCALE = breaks EVERYTHING. #yow13

rponte

INSERT INTO proposal (
	id, address, created_at, "document", email, "name", salary, status, updated_at
)
select
	 md5(random()::text || clock_timestamp()::text)::uuid as id
	,'Rua das Tabajaras, ' || floor(random() * 9999)::int as address
	,localtimestamp                                       as created_at
	,left(md5(random()::text), 16)                        as "document"
	,left(md5(random()::text), 6) || '@zup.com.br'        as email
	,'Customer ' || left(md5(random()::text), 22)         as "name"