How to visualize data store in postgres. #202
Replies: 3 comments 1 reply
-
Data visualization is not handled by EclipseStore, this must be done by your application. The eclipse store GUI is just a dev tool to view the persisted data for debugging purposes, if you can't use it you need access the loaded data via StorageManager.root(). The data you posted is the storage type dictionary, it’s a description of currently known persist-able java types, consisting of an id, the type name and the persist-able fields, this dictionary consists of default types and custom types encountered during stores. |
Beta Was this translation helpful? Give feedback.
-
@hg-ms Thanks for the response. I just have a concern, how the reporting team will visualize the data? They won't be looking into the application they will be more interested in the data, the traditional way we do for relational data or NoSql using tools like Jetbrain Datagrip or SQL server management studio. And if they want to use the same data for report generation, how this is done in eclipse store. |
Beta Was this translation helpful? Give feedback.
-
Hi, |
Beta Was this translation helpful? Give feedback.
-
I am using a GCP serverless application with micronaut and a GCP background function. I have saved the data to the Postgres SQL as below
0000000000000000001 byte{ primitive 8 bit integer signed, } 0000000000000000002 boolean{ primitive 8 bit boolean, } 0000000000000000003 short{ primitive 16 bit integer signed, } 0000000000000000004 char{ primitive 16 bit integer unicode, } 0000000000000000005 int{ primitive 32 bit integer signed, } 0000000000000000006 float{ primitive 32 bit decimal IEEE754, } 0000000000000000007 long{ primitive 64 bit integer signed, } 0000000000000000008 double{ primitive 64 bit decimal IEEE754, } 0000000000000000010 java.lang.Object{} 0000000000000000011 java.lang.Byte{ byte value, } 0000000000000000012 java.lang.Boolean{ boolean value, } 0000000000000000013 java.lang.Short{ short value, } 0000000000000000014 java.lang.Character{ char value, } 0000000000000000015 java.lang.Integer{ int value, } 0000000000000000016 java.lang.Float{ float value, } 0000000000000000017 java.lang.Long{ long value, } 0000000000000000018 java.lang.Double{ double value, } 0000000000000000019 java.lang.Void{} 0000000000000000020 java.lang.Class{ long value, } 0000000000000000030 java.lang.String{ [char] value, } 0000000000000000032 java.lang.StringBuffer{ long capacity, [char] value , } 0000000000000000033 java.lang.StringBuilder{ long capacity, [char] value , } 0000000000000000034 java.io.File{ [char] path, } 0000000000000000035 java.util.Date{ long timestamp, } 0000000000000000037 java.math.BigInteger{ [byte] value, } 0000000000000000038 java.math.BigDecimal{ [char] value, } 0000000000000000043 java.util.ArrayList{ long capacity, [list] elements( java.lang.Object element, ), } 0000000000000000044 java.util.HashSet{ float loadFactor, [list] elements ( java.lang.Object element, ), } 0000000000000000046 java.util.HashMap{ float loadFactor, [list] elements ( java.lang.Object key , java.lang.Object value, ), } 0000000000000000048 java.util.Hashtable{ float loadFactor, [list] elements ( java.lang.Object key , java.lang.Object value, ), } 0000000000000000049 java.util.ArrayDeque{ [list] elements( java.lang.Object element, ), } 0000000000000000050 java.util.IdentityHashMap{ [list] elements( java.lang.Object key , java.lang.Object value, ), } 0000000000000000051 java.util.LinkedHashMap{ float loadFactor , boolean accessOrder, [list] elements ( java.lang.Object key , java.lang.Object value, ), } 0000000000000000052 java.util.LinkedHashSet{ float loadFactor, [list] elements ( java.lang.Object element, ), } 0000000000000000054 java.util.LinkedList{ [list] elements( java.lang.Object element, ), } 0000000000000000056 java.util.PriorityQueue{ java.util.Comparator comparator, [list] elements ( java.lang.Object element, ), } 0000000000000000057 java.util.TreeMap{ java.util.Comparator comparator, [list] elements ( java.lang.Object key , java.lang.Object value, ), } 0000000000000000058 java.util.TreeSet{ java.util.Comparator comparator, [list] elements ( java.lang.Object element, ), } 0000000000000000059 java.util.Vector{ int capacityIncrement, long capacity , [list] elements ( java.lang.Object element, ), } 0000000000000000060 java.util.Stack{ int capacityIncrement, long capacity , [list] elements ( java.lang.Object element, ), } 0000000000000000061 java.util.Properties{ java.util.Properties defaults, [list] elements( java.lang.Object key , java.lang.Object value, ), } 0000000000000000062 java.util.concurrent.ConcurrentHashMap{ [list] elements( java.lang.Object key , java.lang.Object value, ), } 0000000000000000063 java.util.concurrent.ConcurrentLinkedDeque{ [list] elements( java.lang.Object element, ), } 0000000000000000064 java.util.concurrent.ConcurrentLinkedQueue{ [list] elements( java.lang.Object element, ), } 0000000000000000065 java.util.concurrent.ConcurrentSkipListMap{ java.util.Comparator comparator, [list] elements ( java.lang.Object key , java.lang.Object value, ), } 0000000000000000066 java.util.concurrent.ConcurrentSkipListSet{ java.util.Comparator comparator, [list] elements ( java.lang.Object element, ), } 0000000000000000068 java.util.Locale{ [char] languageTag, } 0000000000000000101 [B{ [list] elements( byte element, ), } 0000000000000000102 [Z{ [list] elements( boolean element, ), } 0000000000000000103 [S{ [list] elements( short element, ), } 0000000000000000104 [C{ [list] elements( char element, ), } 0000000000000000105 [I{ [list] elements( int element, ), } 0000000000000000106 [F{ [list] elements( float element, ), } 0000000000000000107 [J{ [list] elements( long element, ), } 0000000000000000108 [D{ [list] elements( double element, ), } 0000000000000000110 [Ljava.lang.Object;{ [list] elements( java.lang.Object element, ), } 0000000000000010000 org.eclipse.serializer.reference.Lazy$Default{ java.lang.Object subject, } 0000000000001000001 java.util.Currency{ [char] currencyCode, } 0000000000001000002 java.util.regex.Pattern{ int flags , [char] pattern, } 0000000000001000003 java.net.InetAddress{ [char] address, } 0000000000001000004 java.net.Inet4Address{ [char] address, } 0000000000001000005 java.net.Inet6Address{ [char] address, } 0000000000001000006 java.nio.file.Path{ [char] uri, } 0000000000001000007 java.net.InetSocketAddress{ java.lang.String hostname, java.net.InetAddress address , int port , } 0000000000001000009 java.net.URI{ [char] address, } 0000000000001000010 java.net.URL{ [char] address, } 0000000000001000011 java.time.ZoneOffset{ int totalSeconds, } 0000000000001000013 java.sql.Date{ long timestamp, } 0000000000001000014 java.sql.Time{ long timestamp, } 0000000000001000015 java.sql.Timestamp{ long timestamp, } 0000000000001000016 java.util.OptionalInt{ boolean isPresent, int value , } 0000000000001000017 java.util.OptionalLong{ boolean isPresent, long value , } 0000000000001000018 java.util.OptionalDouble{ boolean isPresent, double value , } 0000000000001000019 java.util.Collections$UnmodifiableNavigableSet$EmptyNavigableSet{} 0000000000001000024 java.util.Collections$UnmodifiableNavigableMap$EmptyNavigableMap{} 0000000000001000028 java.util.Collections$ReverseComparator{} 0000000000001000029 java.util.WeakHashMap{ [list] elements( java.lang.Object key , java.lang.Object value, ), } 0000000000001000030 java.util.concurrent.CopyOnWriteArrayList{ [list] elements( java.lang.Object element, ), } 0000000000001000031 java.util.concurrent.CopyOnWriteArraySet{ [list] elements( java.lang.Object element, ), } 0000000000001000032 java.util.Comparators$NaturalOrderComparator{ enum INSTANCE, } 0000000000001000033 java.util.Optional{ java.lang.Object java.util.Optional#value, } 0000000000001000034 org.eclipse.serializer.collections.BulkList{ long capacity, [list] elements( java.lang.Object element, ), } 0000000000001000039 org.eclipse.serializer.collections.LimitList{ long capacity, [list] elements( java.lang.Object element, ), } 0000000000001000040 org.eclipse.serializer.collections.FixedList{ [list] elements( java.lang.Object element, ), } 0000000000001000041 org.eclipse.serializer.collections.ConstList{ [list] elements( java.lang.Object element, ), } 0000000000001000042 org.eclipse.serializer.collections.EqBulkList{ org.eclipse.serializer.hashing.HashEqualator hashEqualator, long capacity , [list] elements ( java.lang.Object element, ), } 0000000000001000043 org.eclipse.serializer.collections.HashEnum{ float hashDensity, [list] elements ( java.lang.Object element, ), } 0000000000001000045 org.eclipse.serializer.collections.ConstHashEnum{ float hashDensity, [list] elements ( java.lang.Object element, ), } 0000000000001000046 org.eclipse.serializer.collections.EqHashEnum{ org.eclipse.serializer.hashing.HashEqualator hashEqualator, float hashDensity , [list] elements ( java.lang.Object element, ), } 0000000000001000047 org.eclipse.serializer.collections.EqConstHashEnum{ org.eclipse.serializer.hashing.HashEqualator hashEqualator, float hashDensity , [list] elements ( java.lang.Object element, ), } 0000000000001000048 org.eclipse.serializer.collections.HashTable{ org.eclipse.serializer.collections.HashTable$Keys keys , org.eclipse.serializer.collections.HashTable$Values values , float hashDensity, [list] elements ( java.lang.Object key , java.lang.Object value, ), } 0000000000001000050 org.eclipse.serializer.collections.ConstHashTable{ org.eclipse.serializer.collections.ConstHashTable$Keys keys , org.eclipse.serializer.collections.ConstHashTable$Values values , float hashDensity, [list] elements ( java.lang.Object key , java.lang.Object value, ), } 0000000000001000051 org.eclipse.serializer.collections.EqHashTable{ org.eclipse.serializer.hashing.HashEqualator hashEqualator, org.eclipse.serializer.collections.EqHashTable$Keys keys , org.eclipse.serializer.collections.EqHashTable$Values values , float hashDensity , [list] elements ( java.lang.Object key , java.lang.Object value, ), } 0000000000001000052 org.eclipse.serializer.collections.EqConstHashTable{ org.eclipse.serializer.hashing.HashEqualator hashEqualator, org.eclipse.serializer.collections.EqConstHashTable$Keys keys , org.eclipse.serializer.collections.EqConstHashTable$Values values , float hashDensity , [list] elements ( java.lang.Object key , java.lang.Object value, ), } 0000000000001000053 org.eclipse.serializer.collections.Singleton{ java.lang.Object element, } 0000000000001000054 org.eclipse.serializer.util.Substituter$Default{ org.eclipse.serializer.hashing.HashEqualator hashEqualator, float hashDensity , [list] elements ( java.lang.Object element, ), } 0000000000001000055 org.eclipse.serializer.collections.lazy.LazyArrayList{ int maxSegmentSize, int size , org.eclipse.serializer.collections.lazy.LazySegmentUnloader unloader , [list] segments ( int offset, int size , org.eclipse.serializer.reference.ControlledLazyReference data , ), } 0000000000001000056 org.eclipse.serializer.collections.lazy.LazyHashMap{ int maxSegmentSize, int size , org.eclipse.serializer.collections.lazy.LazySegmentUnloader unloader , [list] segments ( int min , int max , int size, org.eclipse.serializer.collections.lazy.LazyHashMap$LazyHashMapSegmentEntryList data, ), } 0000000000001000057 org.eclipse.serializer.collections.lazy.LazyHashMap$LazyHashMapSegmentEntryList{ [list] segments( int hash , java.lang.Object key , java.lang.Object value, ), } 0000000000001000058 org.eclipse.serializer.collections.lazy.LazyHashSet{ org.eclipse.serializer.collections.lazy.LazyHashMap map, } 0000000000001000059 org.eclipse.serializer.reference.ControlledLazyReference$Default{ java.lang.Object subject, } 0000000000001000060 java.util.ImmutableCollections$Set12{ java.lang.Object e0, java.lang.Object e1, } 0000000000001000063 java.util.ImmutableCollections$List12{ java.lang.Object e0, java.lang.Object e1, } 0000000000001000065 org.eclipse.serializer.persistence.types.PersistenceRoots$Default{ [list] instances ( java.lang.Object instance, ), [list] identifiers( [char] identifier, ), } 0000000000001000066 org.eclipse.serializer.persistence.types.PersistenceRootReference$Default{ java.lang.Object root, } 0000000000001000067 org.eclipse.serializer.hashing.XHashing$SingletonValueHashEqualator{} 0000000000001000068 org.eclipse.serializer.hashing.XHashing$SingletonIdentityHashEqualator{} 0000000000001000069 org.eclipse.serializer.hashing.XHashing$SingletonKeyValueIdentityHashEqualator{} 0000000000001000070 org.eclipse.serializer.collections.Empty{} 0000000000001000071 org.eclipse.serializer.collections.EmptyTable{ org.eclipse.serializer.collections.EmptyTable$Keys org.eclipse.serializer.collections.EmptyTable#keys , org.eclipse.serializer.collections.EmptyTable$Values org.eclipse.serializer.collections.EmptyTable#values, } 0000000000001000072 org.eclipse.serializer.collections.EmptyTable$Keys{ org.eclipse.serializer.collections.EmptyTable org.eclipse.serializer.collections.EmptyTable$Keys#this$0, } 0000000000001000073 org.eclipse.serializer.collections.EmptyTable$Values{ org.eclipse.serializer.collections.EmptyTable org.eclipse.serializer.collections.EmptyTable$Values#this$0, } 0000000000001000074 java.util.Collections$EmptyList{} 0000000000001000075 java.util.Collections$EmptySet{} 0000000000001000076 java.util.Collections$EmptyMap{} 0000000000001000077 fete.bird.entity.Root{ java.util.Map fete.bird.entity.Root#documentOcr, } 0000000000001000078 java.util.Map{}
How do I visualize the data, since the data is all encrypted? I cant use the eclipse store GUI, since gcp background function doesn't allow to access it publicly.
Beta Was this translation helpful? Give feedback.
All reactions