Eresh ereshzealous
ereshzealous
/ user_index.json
Created
September 17, 2021 11:12
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "settings": { | |
| "number_of_shards": 2 | |
| }, | |
| "mappings": { | |
| "properties" : { | |
| "_class" : { | |
| "type" : "text", | |
| "fields" : { | |
| "keyword" : { |
ereshzealous
/ consumer-application.yml
Created
September 15, 2021 08:51
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| server: | |
| port: 9081 | |
| spring: | |
| cloud: | |
| schema-registry-client: | |
| endpoint: http://${SCHEMA_REGISTRY_HOST:localhost}:${SCHEMA_REGISTRY_PORT:8081} | |
| stream: | |
| kafka: | |
| binder: |
ereshzealous
/ producer-application.yml
Created
September 15, 2021 08:38
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| server: | |
| port: 9080 | |
| spring: | |
| schema: | |
| avro: | |
| schema-locations: | |
| - classpath:avro/*.avsc | |
| cloud: | |
| schema-registry-client: |
ereshzealous
/ avro-1.avsc
Created
September 15, 2021 08:05
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "namespace": "com.spring.kafka.avro.user", | |
| "type": "record", | |
| "name": "UserEvent", | |
| "fields": [ | |
| { | |
| "name": "eventId", | |
| "type": "string" | |
| }, | |
| { |
ereshzealous
/ ValidationUtil.java
Created
September 7, 2021 10:01
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package com.postgres.jsonb.user.validation; | |
| import com.fasterxml.jackson.databind.JsonNode; | |
| import com.fasterxml.jackson.databind.ObjectMapper; | |
| import com.networknt.schema.JsonSchema; | |
| import com.networknt.schema.JsonSchemaFactory; | |
| import com.networknt.schema.SpecVersion; | |
| import com.networknt.schema.ValidationMessage; | |
| import lombok.AccessLevel; | |
| import lombok.NoArgsConstructor; |
ereshzealous
/ schema.json
Created
September 7, 2021 10:00
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "$schema": "https://json-schema.org/draft/2019-09/schema#", | |
| "$id": "http://my-paintings-api.com/schemas/painting-schema.json", | |
| "type": "object", | |
| "required" : [ | |
| "profession", "gender", "maritalStatus", "dateOfBirth", "fatherName" | |
| ], | |
| "properties" : { | |
| "profession" : { | |
| "type" : "string", |
ereshzealous
/ query14.sql
Created
September 7, 2021 09:29
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| explain analyze select * from user_details where details @> '{"info" : {"crop" : "Corn", "farmSize": "2-3"}}' limit 50; | |
| QUERY PLAN | | |
| ---------------------------------------------------------------------------------------------------------------------| | |
| Limit (cost=0.00..3501.85 rows=50 width=426) (actual time=0.016..0.587 rows=50 loops=1) | | |
| -> Seq Scan on user_details (cost=0.00..262639.00 rows=3750 width=426) (actual time=0.015..0.581 rows=50 loops=1)| | |
| Filter: (details @> '{"info": {"crop": "Corn", "farmSize": "2-3"}}'::jsonb) | | |
| Rows Removed by Filter: 1046 | | |
| Planning Time: 0.058 ms | | |
| Execution Time: 0.613 ms |
ereshzealous
/ query13.sql
Created
September 7, 2021 09:28
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| explain analyze select * from user_details where details -> 'info' ->> 'crop' = 'Corn' and details -> 'info' ->> 'farmSize' = '2-3' limit 50; | |
| QUERY PLAN | | |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------| | |
| Limit (cost=1000.00..136551.01 rows=50 width=426) (actual time=3.764..4.346 rows=50 loops=1) | | |
| -> Gather (cost=1000.00..255835.90 rows=94 width=426) (actual time=0.165..40.441 rows=50 loops=1) | | |
| Workers Planned: 2 | | |
| Workers Launched: 2 |
ereshzealous
/ query12.sql
Created
September 7, 2021 09:27
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| explain analyze select * from user_details where details -> 'info' ->> 'crop' = 'Corn' limit 50; | |
| QUERY PLAN | | |
| ----------------------------------------------------------------------------------------------------------------------| | |
| Limit (cost=0.00..750.37 rows=50 width=426) (actual time=0.015..0.318 rows=50 loops=1) | | |
| -> Seq Scan on user_details (cost=0.00..281389.00 rows=18750 width=426) (actual time=0.014..0.315 rows=50 loops=1)| | |
| Filter: (((details -> 'info'::text) ->> 'crop'::text) = 'Corn'::text) | | |
| Rows Removed by Filter: 210 | | |
| Planning Time: 0.052 ms | | |
| Execution Time: 0.335 ms |
ereshzealous
/ query11.sql
Created
September 7, 2021 09:26
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| explain analyze select * from user_details where to_date(details ->>'dateOfBirth', 'YYYY-MM-DD') between '2000-03-01' and '2000-03-31' limit 50; | |
| QUERY PLAN | | |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | |
| Limit (cost=0.00..825.37 rows=50 width=426) (actual time=0.113..27.525 rows=50 loops=1) | | |
| -> Seq Scan on user_details (cost=0.00..309514.00 rows=18750 width=426) (actual time=0.112..27.515 rows=50 loops=1) | | |
| Filter: ((to_date((details ->> 'dateOfBirth'::text), 'YYYY-MM-DD'::text) >= '2000-0 |