Open Discussion on Project Planning ## Planning in an Agile Environment Key Tenets • Planning should focus strongly on the near term • Eliminate waste caused by planning for eventualities that never processes to enable rapid and frequent delivery of capabilities ## Planning DOs and DON'Ts - DO establish some high-level planning, requirements, processes, and structure; however, activities focus concisely define the desired system functions and provide the foundation for Agile estimation and planning. They describe what the users want to accomplish with the resulting system. User stories help ensure

## Cache-friendly Design in Robot Path Planning ## BRIAN CAIRI 2023 | October ## About Me - This is my first time at CppCon! • Regularly program in C++ for robotics  ## Robot path planning ## Robot path planning Path planning ## Path planning ## How an (autonomous) agent figures out how to get from one location goals of this talk ## • Implement cache-friendly path planning code in C++ ## High level goals of this talk ## • Implement cache-friendly path planning code in C++ • Do so using the STL ## High level goals

## +23 ### BehaviorTree.CPP: Task Planning for Robots and Virtual Agents ## DAVIDE FACONTI ## 20 23 October 01 - 06 ## What you will learn today 1. What Behavior Trees are 2. About the C++ library simulation ☐ Wheeled robots: navigation, localization, 3D perception Robotic arms: control, motion planning ☐ Tooling: logging, data visualization - I love C++, and I learnt a lot thanks to CPPCon videos

Keyspace ID ..... 20 Keyspace ..... 20 MoveTables ..... 20 Identifying Candidate Tables ..... 20 Query Rewriting ..... 20 Replication Graph ..... 25 Shard ..... 25 Shard Naming ..... 25 Resharding 40 PR Naming Conventions ..... 40 Consists of five parts: ..... 41 Description: ..... 41 Query Serving ..... 42 Consistent lookup vindexes ..... 42 Problem ..... 42 Locking functions ... Command Reference ..... 173 Keyspaces ..... 173 Commands ..... 173 See Also ..... 182 vtctl Query Command Reference ..... 182 Queries ..... 182 Commands ..... 182 See Also 186 vtctl Replication

1.1 Overview peewee is a lightweight ORM written in python. ## Examples: Examples: # a simple query selecting a user User.get(User.username == 'charles') # get the staff and super users editors simple twitter-like site • using “fn” • the querying docs, which contain an in-depth overview of the query apis #### 1.3.3 Changes in fields and columns Well, for one, columns are gone. They were a shim peewee and spits out SQL. It works recursively and knows about a few types of expressions: • the query tree • comparison statements like '==', 'IN', 'LIKE' which comprise the leaves

CONTENTS: ### 1.1 Overview peewee is a lightweight ORM written in python. Examples: # a simple query selecting a user User.get(username='charles') # get the staff and super users editors = User the exception can be caught during the “connect” step, rather than some arbitrary time later when a query is executed. >>> database = SqliteDatabase('stats.db') >>> database.connect() records, issue an UPDATE query. The following example will update all Entry objects, marking them as “published”, if their pub_date is less than today’s date. >>> update_query = Entry.update(published=True)

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 1.8 Query operators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181 1.12 Query Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233 1.13 Query Builder . . . . . . . . . . . . . . . . minutes to go through it. • Example Twitter app written using Flask framework. • Guide to the various query operators describes how to construct queries and combine expressions. • Field types table lists the

Contributing 17 1.6 Managing your Database 17 1.7 Models and Fields 35 1.8 Querying 50 1.9 Query operators 64 1.10 Foreign Keys 68 1.11 Performance Techniques 74 1.12 Transactions 78 1.13 bare essentials. It will take you between 5 and 10 minutes to go through it. • Guide to the various query operators describes how to construct queries and combine expressions. • Field types table lists the with your database connection immediately, as opposed to some arbitrary time later when the first query is executed. It is also good to close the connection when you are done – for instance, a web app might

configuration Connection Management Users Teams Authentication methods User credentials storage Query Manager Drivers Management Supported databases features Database navigator DB Navigator JSON and Document View Data export Entity Diagrams SQL Editor Query Execution Plan Visual Query Builder Log Viewer Query History Resource Manager Installation Installation Version upgrade Execute SQL query 1. Open a new connection 2. Click SQL in the main menu 3. SQL editor with results panel is opened 4. Write SQL query and press Ctrl-Enter or click the Execute icon 5. Query results will

dictionaries / namedtuples ○ Returning Clause ○ Common Table Expressions ○ Foreign Keys and Joins • Query operators ○ Three valued logic ○ Adding user-defined operators ○ Expressions the N+1 problem • API Documentation ○ Database ○ Query-builder ○ Fields ○ Schema Manager ○ Model ○ Query-builder Internals • Constants and Helpers • SQLite Extensions Util • Query Examples • Model Definitions • Schema Creation • Basic Exercises • Joins and Subqueries • Modifying Data • Aggregation • Recursion • Query Builder