goodid | 快速 a short ID generator

I have a spring boot service that should persist several entities of two types in a transaction to an Oracle DB. The table for the first entity type is huge (3 Mio. entries/day, partitioned,...) and I have the issue that I need to react on duplicates. There are some fields I use to create a hash on and I have a unique constraint in the database on that field. I thought it is a clever idea to just saveAndFlush entity by entity and react on the ConstraintViolationException. Based on the result of saving the list of first entities, I need to create the second entity and save that as well, but it rolls back everything. My question now would be if this approach is generally wrong, or ok and there is some small issue? If it is generally wrong, how should I do this duplicate check then (a select upfront is not an option)?

Here is some pseudo-code to get a better idea

I want to create a table in SQlite but can't:

I created a page with a form. When I tried it in chrome the scaling in works just fine. After I created a google app script page the scaling is not working properly when I try mobile size. it works when I put the mobile in landscape mode. In Firefox it works.

My first page was made with materializecss. First time I tried so I thought there was a problem with that. I recreated the page with bootstrap, same result. I can't find the problem. Hope you can help me. I create the select with data from a spreadsheet.

I'm using attributes in HTML tags to control data. how should I set data-val value dynamically?

I'm setting up a new configuration for an application. according to this configuration, I need to set the data-Val attribute dynamically in the tag. when I write data-val="true", It works Ok. but when set it's value dynamically, It doesn't work. Note that the type of tisApp.insuranceCertificateVM.insuranceCertificate().HasForbiddenGoods() is boolean .

I expect when I use tisApp.insuranceCertificateVM.insuranceCertificate().HasForbiddenGoods() for data-val It works by it's value .

I have done an array.map() that loop through json file (goods.json). Then I want to make some manipulations with it (want to delete item from this array in removeCard(obj) method for example). Render is ok but the problem is that I don't understand why I can't see shoppingCardsJSX array in removeCard(obj) method, always get underfined. I have read answers in How to delete a ToDo Item onClick in React? and Remove item from array in React but unfortunately I didn't understand how it works. Can you please help me find out what I'm doing wrong ? Hope this part of code can illustrate my problem,

I want to create a datastore class that holds some goods and their amount. An example would be a shopping cart with some articles and their amount.

This Store class should behave like a database cross table

I have a 5 tables in mysql. And when I want execute query it executed too long. There are structure of my tables:

1. Reciept(count rows: 23799640)reciept table structure
2. reciept_goods(count rows: 39398989)reciept_goods table structure
3. good(count rows: 17514)good table structure
4. good_categories(count rows: 121)good_categories table structure
5. retail_category(count rows: 10)retail_category table structure

My Indexes:

1. Date -->reciept.date #1
2. reciept_goods_index --> reciept_goods.recieptId #1, reciept_goods.shopId #2, reciept_goods.goodId #3
3. category_id -->good.category_id #1

I have a next sql request:

Sorry for not precise subject. More precise description is here: Consider example tables:

City:

Hi I am building a sample of f# from https://fsharpforfunandprofit.com/posts/elevated-world-3/ in c#.

My code is as below,