Site Map

Main Sections

• About - Learn more about Francesco Tisiot
• Suggestions - Restaurant and activity suggestions for Verona
• PostgreSQL JSON - Complete guide to PostgreSQL JSON functions
• MySQL JSON - Complete guide to MySQL JSON functions

Content Categories

PostgreSQL JSON Tutorials

• Array from Elements - Build JSON arrays from elements
• Types - JSON vs JSONB differences
• Extract - Extract data from JSON
• Edit - Modify JSON content
• Create - Create JSON objects
• Array - JSON array operations
• Contains - Check JSON content
• Keys - Extract JSON keys
• Remove Fields - Remove JSON properties
• Prettify - Format JSON output

MySQL JSON Tutorials

• Create - Create JSON in MySQL
• Extract - Extract JSON data
• Edit - Modify MySQL JSON
• Types - MySQL JSON data types
• Array - Array operations
• Search - Search within JSON
• Remove - Remove JSON elements
• Merge - Combine JSON objects
• Insert - Insert JSON data
• Tabulate - Convert to tables

Blog Posts

• 1 Billion Rows Challenge - PostgreSQL vs ClickHouse performance
• 1 Billion Rows Challenge in MySQL - MySQL performance comparison
• 2019: A Year of Conferences and Much More - Conference highlights
• A Month in Aiven - First month experience at Aiven
• A Talk for One - Speaking experiences
• Aiven CLI - Command line interface guide
• Aiven DB Optimizer - Database optimization
• Apache Flink to Timestamp LTZ - Timestamp conversion
• Convert Blog to Hugo and GitHub Pages - Blog migration
• Create JSON Connection in PG Admin 4 - Database connections
• DBF to PostgreSQL with Python - Data migration
• First Blog Post - Welcome message
• From Data Stack to Data Stuck - Platform evaluation risks
• How to Search the Cause of Errors - Error troubleshooting
• ITOUG Call for Papers is Open - Conference submissions
• ITOUG Call for Papers Submission Analysis - Analysis insights
• JQ KCat Consumer - Kafka consumer tools
• Kafka Connect Sink ElasticSearch OpenSearch Timestamp - Timestamp handling
• Kafka Consume HTTP - HTTP integration
• List of PostgreSQL AI Resources - AI resources
• Looker for OBIEE Experts - Analytics comparison
• Looking Back - Career reflection
• Looking Forward - Future plans
• MySQL Concat - String functions
• OBI Blogs to Follow - Recommended blogs
• OBI12c Performance Tiles PDF Print Error - Troubleshooting
• OBI12c SSL with Custom Certificates - SSL configuration
• Oracle Analytics Cloud 5.7 Use ML Models - Machine learning
• Oracle Analytics Server and Kerberos Authentication - Authentication
• pgbench Test PostgreSQL - Performance benchmarking
• PostgreSQL Community - Community experience
• PostgreSQL ISNULL - Handling NULL values
• PostgreSQL SUBSTR - String manipulation
• Pros and Cons of Multi-Step Data Platforms - Architecture analysis
• Query InfluxDB with cURL - Database queries
• Remove OBI12c Data Visualisation - Configuration
• Soft Data Platforms Why - Platform analysis
• SQL Optimizer - Query optimization
• StackOverflow PostgreSQL - Community resources
• Staff DA - Data analysis
• Tech Scalability - Scalability insights
• Tips for Abstract Writing - Writing advice
• Useless Slides - Presentation tips
• What’s My Talk Age Again - Speaking reflections

Speaking & Presentations

• Talks - Conference presentations and talks
• Slides - Presentation materials and resources

Overall pages

• Categories - Browse content by category
• Components - Browse content by components
• Tags - Browse content by tag
• Search - Search content