SQLite Development with Zumero SQLite Development with Zumero Copyright © 2013 Zumero LLC iii Table of Contents 1. Introduction .................................................................... ................................................................. 5 3.7. Limitations of SQLite virtual tables .......................................................................... 5 3.7.1. Indexes ........................................................ 5 3.7.2. Adding columns to an existing table .............................................................. 6 3.7.3. Incremental blob I/O ...

Algorithm 238 Relaxed Rules for Specifying Table Distribution Columns 239 Resource Groups Features 239 PL/pgSQL Procedural Language Enhancements 239 Replicated Table Data 240 Concurrency Improvements in Requirements 263 Operating System 263 Storage 263 Security 264 Amazon Web Services (AWS) 264 Virtual Machine Type 264 Compute 264 Memory 264 Network 264 Storage 264 Elastic Block Storage (EBS) Ephemeral 265 AWS Recommendations 265 Master 265 Segments 265 Google Compute Platform (GCP) 266 Virtual Machine Type 266 VMware Greenplum 6 Documentation VMware, Inc 11 Compute 266 Memory 266 Network

Algorithm 228 Relaxed Rules for Specifying Table Distribution Columns 228 Resource Groups Features 229 PL/pgSQL Procedural Language Enhancements 229 Replicated Table Data 229 Concurrency Improvements in Recommendations 251 Operating System 251 Storage 252 Security 252 Amazon Web Services (AWS) 252 Virtual Machine Type 252 Compute 252 Memory 252 Network 253 Storage 253 Elastic Block Storage (EBS) Compute Platform (GCP) 254 Virtual Machine Type 254 Compute 254 Memory 254 Network 254 Storage 254 GCP Recommendations 255 Master and Segment Instances 255 Azure 255 Virtual Machine Type 256 Compute

Algorithm 231 Relaxed Rules for Specifying Table Distribution Columns 231 Resource Groups Features 232 PL/pgSQL Procedural Language Enhancements 232 Replicated Table Data 232 Concurrency Improvements in Recommendations 255 Operating System 255 Storage 255 Security 256 Amazon Web Services (AWS) 256 Virtual Machine Type 256 Compute 256 Memory 256 Network 256 Storage 256 Elastic Block Storage (EBS) Compute Platform (GCP) 258 Virtual Machine Type 258 Compute 258 Memory 258 Network 258 Storage 258 GCP Recommendations 259 Master and Segment Instances 259 Azure 259 Virtual Machine Type 260 Compute

Algorithm 257 Relaxed Rules for Specifying Table Distribution Columns 257 Resource Groups Features 258 PL/pgSQL Procedural Language Enhancements 258 Replicated Table Data 258 Concurrency Improvements in Requirements 281 Operating System 281 Storage 282 Security 282 Amazon Web Services (AWS) 282 Virtual Machine Type 282 Compute 282 Memory 282 Network 283 Storage 283 Elastic Block Storage (EBS) Compute Platform (GCP) 284 Virtual Machine Type 284 Compute 284 Memory 284 Network 284 Storage 284 GCP Recommendations 285 Master and Segment Instances 285 Azure 285 Virtual Machine Type 286 Compute

Algorithm 207 Relaxed Rules for Specifying Table Distribution Columns 207 Resource Groups Features 207 PL/pgSQL Procedural Language Enhancements 208 Replicated Table Data 208 Concurrency Improvements in Recommendations 228 Operating System 228 Storage 228 Security 229 Amazon Web Services (AWS) 229 Virtual Machine Type 229 Compute 229 Memory 229 Network 229 Storage 229 Elastic Block Storage (EBS) Compute Platform (GCP) 230 Virtual Machine Type 230 Compute 231 Memory 231 Network 231 Storage 231 GCP Recommendations 231 Master and Segment Instances 232 Azure 232 Virtual Machine Type 232 Compute

Algorithm 271 Relaxed Rules for Specifying Table Distribution Columns 271 Resource Groups Features 271 PL/pgSQL Procedural Language Enhancements 272 Replicated Table Data 272 VMware Greenplum 6 Documentation Public Cloud Requirements 295 Operating System 295 Storage 295 Amazon Web Services (AWS) 295 Virtual Machine Type 295 Compute 296 Memory 296 Network 296 Storage 296 Elastic Block Storage (EBS) Compute Platform (GCP) 297 Virtual Machine Type 297 Compute 297 Memory 298 Network 298 Storage 298 GCP Recommendations 298 Master and Segment Instances 299 Azure 299 Virtual Machine Type 299 Compute

Navigation Data View and Format Data Filters Data Refresh Data Viewing and Editing User Guide Table of contents DBeaver Desktop Documentation General User Guide DBeaver User Guide 23.2. Page 3 of SQL Generation Working with spatial/GIS data Working with XML and JSON Managing Data Formats Virtual column expressions Properties Editor ER Diagrams Database Structure Diagrams Custom Diagrams JDBC OCI driver Importing CA certificates from your local Java into DBeaver SSL configuration New Table Creation Creating columns Implementing Constraints Utilizing Foreign-Keys Creating Indexes Incorporating

1 Table of Contents Chapter 1 - Introduction 4 About Navicat Data Modeler 4 Installation 5 Registration 6 Migration / Upgrade 7 End-User License Agreement 7 Chapter 2 - User Interface Conversion 71 Auto Layout (Available only in Non-Essentials Version) 71 Print & Export Model 72 Virtual Grouping (Available only in Non-Essentials Edition) 72 Search Filter 73 Dark Theme 74 Full • Forward engineer a physical model to a SQL file or a database/schema. • Create and edit table structures directly. • Support Navicat Cloud and Navicat On-Prem Server. For details, visit our

Create Connection Database navigator DB Navigator toolbar DB Navigator Settings menu User Guide Table of contents CloudBeaver Documentation User Guide CloudBeaver User Guide 23.3. Page 3 of 252. DB to remote database Navigate database structure View properties of database object View and edit table data Execute SQL query Select in a main menu Connection > Manual > Custom Select database Set Set connection options and driver properties and press button Connect Application overview Table of contents Overview Open connection to remote database CloudBeaver User Guide 23.3. Page 8 of 252