C++20 ❤ SQL John R Bandela, MDOverview u SQL u C++ Example u Implementation techniques u fixed_string u meta_struct u Parsing compile time strings into meta_structsOverview v SQL v C++ Example {price_from_user};Avoiding SQL Injection Attacks SELECT orders.id, name, item, price, discount_code FROM orders JOIN customers ON customers.id = customerid WHERE price > ?;SQL Library Options u Traditional Lots of information available u Vulnerable to sql injection of developer not careful u Use dynamic typingDomain Specific Language u Use types to encode SQL u Looks more like regular C++ u Typically requires

C++ Microsoft C++ Getting Started with C++ & CMake Hello again, WorldMicrosoft C++ IDE or Code Editor (VS Code, Visual Studio) What you’ll need to develop in C++ Want to learn more? Check out the "Back IntelliSense across your files Download the Extension of Your Choice: Jupyter Notebooks • Use C#, Python, SQL, PowerShell, and more in one notebook • Invoke executable scripts What if I’m working with multiple

连这些基础都不清楚的人，不能要求自己冒冒然就开始用Visual C++、用MFC、用对象 导向的方式去设计一个你根本就不懂其运作原理的程序。 还没学会走之前，不要跑！ Dialog Editor Image Editor Font Editor .DLG .BMP .BMP .ICO .ICO .CUR .CUR .FON .FON .RC .H .C RC Compiler LINKER C Compiler 第㆓篇 欲善工事先利其器 234 AppWizard Visual C++ IDE ClassWizard .ICO .RC .BMP Resource files Resource Editor .DEF .CPP .H .DSW .DSP Source files Your Application Build Create 四个重要的工具 完全依赖整合环境，丢掉PE2（ 可不能反悔（只能加油添醋）， 所以下手前需三思-- 每一个project 使用AppWizard 的机会只有一次。 ■ Resource Editor：这是一个总合资源编辑器，RC 档内的各种资源它统统都有办 法处理。Resource Editor 做出来的各类资源与你的程序代码之间如何维系关系？ 譬如说对话框中的一个控制组件被按下后程序该有什么反应？ 这就要靠 ClassWizard

ms/cppconVisual Studio Code #1 most-used code editor Source: Stack Overflow Developer Survey 2021Visual Studio Code - Free - Cross-platform - Lightweight #1 most-used code editor Source: Stack Overflow Developer #1 most-used code editor Source: Stack Overflow Developer Survey 2021Visual Studio Code - WSL - SSH - Containers - Free - Cross-platform - Lightweight #1 most-used code editor Source: Stack Overflow CMake - Make - WSL - SSH - Containers - Free - Cross-platform - Lightweight #1 most-used code editor Source: Stack Overflow Developer Survey 2021Visual Studio Code What’s new?Visual Studio Code What’s

comparisonSimple SQL Database ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● Line 16916 Line 18974 Line 40345 −50% −25% 0% 25% 0% 50% 0% 50% 0% 50% Line Speedup Program SpeedupSimple SQL Database #if … }; #endifSimple SQL Database void sqlite_unlock(lock* l) { global_config.unlock(l); } Indirect Call Cheap, but almost the same cost as pthread_mutex_unlockSimple SQL Database void sqlite_unlock(lock*

Studio Code Our agenda todayVisual Studio Code #1 most used code editor [StackOverflow Developer Surveys] Free, open-source code editor Runs on Windows, macOS, and Linux C++ IntelliSense, debug & code ms/github-copilot-features • Activate within Visual Studio • Includes GitHub Copilot Chat and editor suggestions • Enables GitHub Copilot-powered features. Look for: • Works with any repository, even Inline GitHub Copilot Chat ( Alt+/ ) GitHub Copilot Chat Window ( Ctrl+\,C ) or GitHub Copilot Editor Suggestions ( Tab to accept )Visual Studio Agenda 1. Productivity 2. Game Development 3. MSVC

today Visual Studio Code Session coming up! #1 most used code editor [StackOverflow Developer Surveys] Free, open-source code editor Runs on Windows, macOS, and Linux C++ IntelliSense, debug & code SSH/container/WSL remote experiences and much much more… https://aka.ms/cpp/code Thu 10/28 – 2pm An Editor Can Do That? Debugging Assembly Language and GPU Kernels in Visual Studio Code Julia Reid – _3 Luparu Thursday 28th • C++20’s Calendars and Time Zones in MSVC – Miya Natsuhara • An Editor Can Do That? Debugging Assembly Language and GPU Kernels in Visual Studio Code – Julia Reid • Why

Static linking app editor.o file.o line.o search.o source.o23 CppCon 2021 | Static linking static libraries app editor.o file.o line.o search.o source.o libed.a editor.o file.o line.o libre a search.o24 CppCon 2021 | Dynamic linking app libed.so => libre.so => source.o libed.so editor.o file.o line.o libre.so search.o25 CppCon 2021 | • Decompose an application’s material for shipping

Studio Code Our agenda todayVisual Studio Code #1 most used code editor [StackOverflow Developer Surveys] Free, open-source code editor Runs on Windows, macOS, and Linux C++ IntelliSense, debug & code Alignment Visualize Macro Expansion #include Cleanup (Preview Feature) Make Member Function constCore Editor Improvements Spell Checker Sticky Scroll & Brace Pair Colorization All-in-One Search Preview

toolchainsEditor or Integrated Developer Environment (IDE) A matter of focus and out-of-the-box behavior Editor IDE Focused on text editing Syntax highlighting Bundled experience Usually tightly integrated cpptools-extension-pack Ubuntu: sudo snap install code --classic macOS: use the downloaded installerPopular C++ editor/IDEs vim and Neovim 0 5 10 15 20 25 30 35 40 https://www.vim.org and https://neovim.io compiler toolchain separately Free license Go Deeper CppCon 2022 - C++ Coding with NeovimPopular C++ editor/IDEs vim and Neovim 0 5 10 15 20 25 30 35 40 Windows: winget install Neovim.Neovim Ubuntu: