Одну секунду
Что-то сучилось. Попробуйте еще раз.
Golang pgx смотреть последние обновления за сегодня на .
In this video, we'll learn how to switch Golang's DB driver for Postgres from lib/pq to pgx. - Tech School's home page: 🤍 - Join us on Discord: 🤍 - Get the course on Udemy: 🤍 - Buy us a coffee: 🤍 - Full series playlist: 🤍 - GitHub repository: 🤍 - In this backend master class, we’re going to learn everything about how to design, develop, and deploy a complete backend system from scratch using PostgreSQL, Golang, and Docker. TECH SCHOOL - From noob to pro 🤍 At Tech School, we believe that everyone deserves a good and free education. We create high-quality courses and tutorials in Information Technology. If you like the videos, please feel free to share and subscribe to support the channel or buy us a coffee: 🤍
Let me share with you some tips for using and accessing PostgreSQL when building Web Services! What are the pros? What are the cons? What are the best packages to use? What are the guidelines and best practices? * Part 2: 🤍 * Blog Post: 🤍 * Example code: 🤍 * Playlist "Golang Tools and Packages": 🤍 * Playlist "Building Microservices in Go/Golang": 🤍 = Packages used * database/sql with github.com/lib/pq * 🤍 * 🤍 Subscribe: 🤍 - Who am I: Hello👋🏼! I'm Mario, a Hands-on Software Architect and Lead Backend Engineer with more than 16 years of professional experience building all kinds of software including on-premise Industrial Automation Systems, Linux Accessibility Desktop and Browser Components as well as Distributed Advertising Microservices. Every week I will share with you different topics I've learned while working for small startups and large companies including the processes I've followed over the years for successfully delivering complex enterprise systems from start to end. Subscribe if you like Software Development, Software Architecture and Systems Design! Keep it up. Don't give up! #golang #microservices #postgres - Our affiliate links below Shop our favorite products → 🤍 Vlogging setup → 🤍 Get a 30 day FREE trial of Epidemic Sound → 🤍 Try Amazon Prime 30-Day FREE trial → 🤍 I love getting Cash Back and think you will too! Join for free and get $20 when you spend $20 → 🤍 Sign up to start using vidIQ to grow your YouTube channel for FREE → 🤍 - Our Vlog Channel 🤍
Let's learn about using Transactions when working with Relational Databases in Go/Golang using the standard library, using "database/sql", and a concrete driver, which in this case is going to be "pgx"; and also a different third-party implementation that is coming from the "pgx" package itself! This episode covers the methods used in Go/GoLANG to interact with transactions specifically, when using "database/sql" in the standard library we can use: * Begin a Transaction: "DB.BeginTx" (also "DB.Begin" works) * Commit a Transaction: "Tx.Commit" * Rollback a Transaction: "Tx.Rollback" Also when using "jackc/pgx" we can directly use: * "Conn.BeginTx", or * "Conn.BeginTxFunc" When using Transactions in Go/Golang the important things to keep in mind are: * Do not call the original "db" after the transaction was created, use "tx" instead. * Do not call directly "BEGIN", "COMMIT" or "ROLLBACK", instead use the methods defined in the API Relevant links * Example code: 🤍 * PostgreSQL driver and toolkit for Go: 🤍 * Previous Episode: "Learning Golang: Relational Databases - Introduction to database/sql": 🤍 * "Software Architecture in Golang: Security - Databases, SQL Injection and Permissions" 🤍 * "Learning Golang: Context package: Cancellations, Deadlines and Request-scoped values" 🤍 All Go/Golang video series covered * Playlist "Learning Go": 🤍 * Playlist "Software Architecture in Go": 🤍 * Playlist "Learning Go/Golang Concurrency Patterns" 🤍 * Playlist "Building Microservices in Go": 🤍 * Playlist "GoTools and Packages": 🤍 * Playlist "Testing in Go": 🤍 Socials * 🤍 * 🤍 * 🤍 00:00 - Start 01:00 - Example using Transactions with database/sql 16:46 - Example using Transactions with jackc/pgx 25:40 - Conclusions - Who am I: Hello👋🏼! I'm Mario, a Hands-on Software Architect and Lead Backend Engineer with more than 16 years of professional experience building all kinds of software including on-premise Industrial Automation Systems, Linux Accessibility Desktop and Browser Components as well as Distributed Advertising Microservices. Every week I will share with you different topics I've learned while working for small startups and large companies including the processes I've followed over the years for successfully delivering complex enterprise systems from start to end. Subscribe if you like Software Development, Software Architecture and Systems Design! Keep it up. Don't give up! #golang #tutorial #databases = Our Vlog Channel 🤍 = Our affiliate links below ■ My Amazon Storefront: 🤍 ■ Shop my IG posts on my shopLTK page: 🤍 ■ Vlog camera: Sony RX100 VII 🤍 ■ Other vlog cameras and gear: 🤍 ■ Shop through my links to support the channel: 🤍 ■ Get a 30 day FREE Trial of Epidemic Sound: 🤍 ■ Join Rakuten for FREE and get $30 when you spend $30: 🤍 DISCLAIMER: Some of the links shared in the description are affiliate links. As a member of these affiliate programs, I earn a small commission from your purchases at no additional cost to you. I appreciate your support! 💖
Обсудим с какими сложностями приходится сталкиваться, делая Go-платформу и, в качестве примера, проведем сессию траблшутинга проблем с драйвером PostgreSQL. Спикер: Семён Эйгин, разработчик отдела языковой платформы в Ozon Мы Tech-команда, которая создает e-grocery сервис #1 в России и делает это с любовью. Telegram: 🤍 VK: 🤍 Блог на Хабре: 🤍 Вакансии: 🤍 Подкаст «Для tech и этих»: 🤍
Привет! Начинаю серию роликов про работу с PostgreSQL в языке Go. В первой части разберем фреймворки, напишем клиента и создадим БД. А вот кстати запуск докер контейнера с PSQL: docker run name name-postgres -p 5432:5432 -e POSTGRES_PASSWORD=postgres -d postgres:14-alpine Исходный код тут: 🤍 Приятного просмотра! С радостью хочу вам представить, что я запускаю курс “Начальная подготовка” по языку Golang. Курс как для совсем начинающих в сфере IT, так и для тех, кто хочет просто изучить язык Go. Курс доступен в 3 вариациях: 1. Онлайн курс с лекциями, заданиями, чатом менторской поддержкой. 2. Полный видеокурс 3. Отдельные блоки с лекциями Больше обо мне и курсах можно прочитать здесь: 🤍 Записаться на курс можно вот тут: 🤍 А видео курс тут: 🤍 А отдельные блоки с видео тут: 🤍 Больше информации есть в ролике на ютубе: 🤍 На все вопросы могу ответить в Телеграм группе канала и в личных сообщениях. Другие видео: Уроки по Golang. Advanced. REST API. Вебсервер. 🤍 Изучаем Python. Урок 1. Основы. Бонус: Пишем приложение на FastAPI 🤍 Изучаем Golang. Урок 1. Основы + веб-сервер в 3 строки в конце урока! 🤍 Разработка системы заметок на Python, Golang и микросервисы в 2021 году 🤍 Как стать разработчиком. Часть 1 🤍 Что такое микросервисы за 200 секунд 🤍 Что такое Apache Kafka за 200 секунд 🤍 Telegram Group: 🤍 VK: 🤍 Дружественный Golang чат: 🤍 Меня зовут Артур Карапетов и я занимаюсь всем, что связано с разработкой. Я создаю высоконагруженные информационные системы, стартапы, занимаюсь личным обучением людей в сфере разработки (программисты, аналитики, системные администраторы), также я помогаю компаниям и стартапам с обучением людей работать и повышением их квалификации, об этом можно почитать здесь: 🤍. На этом канале я выкладываю ролики на интересующие меня темы, здесь можно найти серию роликов про создание информационной системы с нуля, а также можно найти серию уроков по языкам, которые я люблю. Добро пожаловать и хорошего просмотра! #golang #урок #postgresql #rest #микросервисы #microservices #jetbrains #goland #tutorial #голенг #development #howto #learnbasics #coding #programming #изучаемIT #программирование #разработка
Working effectively with databases is an essential skill for any programmer, and often that means working with Postgres. But with so many different drivers, ORMs, frameworks, how do you choose which tools to use? Follow Johan Brandhorst-Satzkorn on a journey through the tooling to arrive at a productivity station.
In this series, I will teach you how to build a complete industry-ready JSON API project in Golang with JWT authentication, Postgresql, and Docker. We are going to build a bank API and build everything from scratch with only the mandatory packages we actually need. We are also going to write tests for each of our HTTP handlers. If you want to learn Golang or Rust consider subscribing to my channel so you can become a high-value engineer. This golang tutorial is something for you if you are willing to learn about Golang testing, Golang project structure, and how to use Docker with Golang. 📢 I am also building a Discord community! Feel free to join if you are willing to learn about blockchain, web3, Defi, and quantitative trading. Or just hang out and chat. 🤍 ► Support me on PATREON and get access to exclusive lessons, tutorials, and LIVE streams 🤍 ► Join my Discord community for free education 🤍 ► Follow me on GitHub 🤍 ► Follow me on Twitter 🤍 #golang #docker
In this episode, we continue the mission from episode 10: upgrading CockroachDB's internal client interfaces from using lib/pq to pgx. We were able to get started on this in earnest after some internal progress on adding Go Module support to CockroachDB, which is required to use the latest version of pgx. CockroachDB GitHub: 🤍 Check out LARGE DATA BANK live on Twitch every Friday at 3 PM EST: 🤍
► Join my Discord community for free education 👉 🤍 ► Exclusive Lessons, Mentorship, And Videos 👉 🤍 ► Learn Golang Like A Pro 👉 🤍 ► Learn how I became a self-taught software engineer 👉🤍 ► Follow me on Twitter 👉 🤍 ► Follow me on GitHub 👉 🤍 SUBSCRIBE OR NO MARGARITAS ╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗ ║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣ ╠╗║╚╝║║╠╗║╚╣║║║║║═╣ ╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
Let's learn about accessing Relational Databases in Go/Golang using the standard library, specifically using "database/sql" and a concrete driver, which in this case is going to be "pgx". This first episode introduces you to "database/sql" the default way to access Relational Databases in Go/Golang, I will cover the basic instructions to: * Open a Connection using "sql.Open" * Ping the connection using "db.PingContext" (also "db.Ping" works) * Query one row using "db.QueryRowContext" (also "db.QueryRow" works) * Query multiple rows using "db.QueryContext" (also "db.Query works) * Inserting records using "db.ExecContext" (also "db.Exec" works) This is the foundation of future videos that will come, also a few things to keep in mind regarding Relational Databases in Go/Golang: * Go/Golang does not provide any official drivers, however it provides database/sql * Typically drivers implement only that interface, but some like pgx add their own * Nowadays we should be using the context-like methods when accessing databases Relevant links * Example code: 🤍 * PostgreSQL driver and toolkit for Go: 🤍 * Previous Episode: "Learning Golang: Functional Options / Default Configuration Values Pattern": 🤍 * "Software Architecture in Golang: Security - Databases, SQL Injection and Permissions" 🤍 * "Learning Golang: Context package: Cancellations, Deadlines and Request-scoped values" 🤍 All Go/Golang video series covered * Playlist "Learning Go": 🤍 * Playlist "Software Architecture in Go": 🤍 * Playlist "Learning Go/Golang Concurrency Patterns" 🤍 * Playlist "Building Microservices in Go": 🤍 * Playlist "GoTools and Packages": 🤍 * Playlist "Testing in Go": 🤍 Socials * 🤍 * 🤍 * 🤍 00:00 - Start 02:34 - Importing pgx for PostgreSQL in Golang 07:00 - Connecting to PostgreSQL using pgx in Golang 11:10 - Selecting row in PostgreSQL using pgx in Golang 15:20 - Inserting records in PostgreSQL using pgx in Golang 20:50 - Selecting multiple rows in PostgreSQL using pgx in Golang 24:40 - Conclusions - Who am I: Hello👋🏼! I'm Mario, a Hands-on Software Architect and Lead Backend Engineer with more than 16 years of professional experience building all kinds of software including on-premise Industrial Automation Systems, Linux Accessibility Desktop and Browser Components as well as Distributed Advertising Microservices. Every week I will share with you different topics I've learned while working for small startups and large companies including the processes I've followed over the years for successfully delivering complex enterprise systems from start to end. Subscribe if you like Software Development, Software Architecture and Systems Design! Keep it up. Don't give up! #golang #tutorial #databases = Our Vlog Channel 🤍 = Our affiliate links below ■ My Amazon Storefront: 🤍 ■ Shop my IG posts on my shopLTK page: 🤍 ■ Vlog camera: Sony RX100 VII 🤍 ■ Other vlog cameras and gear: 🤍 ■ Shop through my links to support the channel: 🤍 ■ Get a 30 day FREE Trial of Epidemic Sound: 🤍 ■ Join Rakuten for FREE and get $30 when you spend $30: 🤍 DISCLAIMER: Some of the links shared in the description are affiliate links. As a member of these affiliate programs, I earn a small commission from your purchases at no additional cost to you. I appreciate your support! 💖
Приглашаем на конференцию HighLoad 2023, которая пройдет 27 и 28 ноября 2023 в Москве! Программа, подробности и билеты по ссылке: 🤍 Saint HighLoad 2019 Тезисы и презентация: 🤍 В докладе расскажу о практиках работы с Postgres в сервисах на Go. Поговорим о преимуществах и недостатках основных инструментов, которые принято использовать при работе с Postgres в Go. Конечно, коснёмся нюансов, которые нужно учитывать, когда ваши сервисы работают внутри Kubernetes облака. Также расскажу об опыте Avito в предоставлении базы данных разработчикам продукта. ... Нашли ошибку в видео? Пишите нам на support🤍ontico.ru
В докладе рассказывается о практиках работы с Postgres в сервисах на Go. Поговорим о преимуществах и недостатках основных инструментов, которые принято использовать при работе с Postgres в Go. Коснёмся нюансов, которые нужно учитывать, когда ваши сервисы работают внутри Kubernetes облака. Также расскажем об опыте Avito в предоставлении базы данных разработчикам продукта. Слушатели смогут предупредить проблемы при работе с Postgres в своих сервисах, что позволит им избежать неявного поведения и трудно-находимых ошибок, и даже падений базы. Для разработчиков доклад будет полезен своей прикладной составляющей — как и что менять в коде, чтобы избежать ошибок. Для DBA доклад может быть интересен благодаря свежему взгляду на нюансы работы с базой с точки зрения разработчика и позволит увидеть, на что обращать внимание при введении в строй новых сервисов.
If you use Postgres and Go then probably you are using pgx somewhere in your stack. If you are not, then you probably should. Jack Christensen, author of pgx, shows how everything is layered together. Starting at the top with stdlib, going lower to pgx, then to pgtype and so forth. Each layer has interesting things you can do with them. 🤍 🤍 00:00:00 - Introduction 00:01:10 - psql demonstration 00:02:43 - Primary Packages 00:03:15 - stdlib 00:09:15 - pgxpool 00:13:28 - pgx 00:16:40 - CollectRows and other helpers 00:26:31 - Execution Protocols and Value Formats 00:31:44 - Batched Queries 00:37:29 - Other Advanced or Lesser Known Features 00:40:21 - pgtype 00:44:03 - pgtype Plan System 00:51:14 - pgconn 00:53:00 - Extended Protocol 00:54:48 - pgconn Pipeline Mode 00:58:26 - pgconn CopyTo and CopyFrom 01:01:23 - pgproto3 01:01:47 - pgproto3 Debug Tracing 01:03:54 - pgfortune Example 01:04:43 - Outro
Let's learn about Bulk Insert in Relational Databases using Go/Golang specifically using the "pgx" package, but also why using the concrete database engine is better than using a bunch of INSERT commands via "database/sql" This episode covers the concrete methods defined in "pgx" to deal with Bulk Inserts, specifically using the COPY command via the "Conn.CopyFrom" method that requires the following: * tableName Identifier * columnNames []string * rowSrc CopyFromSource Where "CopyFromSource" is a type that we must implement, sort of a reader that indicates "pgx" how to deal with the individual records. Relevant links * Example code: 🤍 * Relational Databases - Bulk Insert - 🤍 * PostgreSQL driver and toolkit for Go: 🤍 * Previous Episode: "Learning Golang: Relational Databases - Transactions with PostgreSQL": 🤍 * "Software Architecture in Golang: Security - Databases, SQL Injection and Permissions" 🤍 * "Learning Golang: Context package: Cancellations, Deadlines and Request-scoped values" 🤍 All Go/Golang video series covered * Playlist "Learning Go": 🤍 * Playlist "Software Architecture in Go": 🤍 * Playlist "Learning Go/Golang Concurrency Patterns" 🤍 * Playlist "Building Microservices in Go": 🤍 * Playlist "GoTools and Packages": 🤍 * Playlist "Testing in Go": 🤍 Socials * 🤍 * 🤍 * 🤍 00:00 - Start 01:00 - Bulk Insert using database/sql via jackc/pgx (inefficient) 11:44 - Bulk Insert using jackc/pgx (efficient) 21:03 - Conclusions - Who am I: Hello👋🏼! I'm Mario, a Hands-on Software Architect and Lead Backend Engineer with more than 16 years of professional experience building all kinds of software including on-premise Industrial Automation Systems, Linux Accessibility Desktop and Browser Components as well as Distributed Advertising Microservices. Every week I will share with you different topics I've learned while working for small startups and large companies including the processes I've followed over the years for successfully delivering complex enterprise systems from start to end. Subscribe if you like Software Development, Software Architecture and Systems Design! Keep it up. Don't give up! #golang #tutorial #databases = Our Vlog Channel 🤍 = Our affiliate links below ■ My Amazon Storefront: 🤍 ■ Shop my IG posts on my shopLTK page: 🤍 ■ Vlog camera: Sony RX100 VII 🤍 ■ Other vlog cameras and gear: 🤍 ■ Shop through my links to support the channel: 🤍 ■ Get a 30 day FREE Trial of Epidemic Sound: 🤍 ■ Join Rakuten for FREE and get $30 when you spend $30: 🤍 DISCLAIMER: Some of the links shared in the description are affiliate links. As a member of these affiliate programs, I earn a small commission from your purchases at no additional cost to you. I appreciate your support! 💖
In this lecture, we'll learn how to config sqlc with v2 syntax, and use it to generate Go codes that talk to Postgres. - Tech School's home page: 🤍 - Join us on Discord: 🤍 - Get the course on Udemy: 🤍 - Buy us a coffee: 🤍 - Full series playlist: 🤍 - GitHub repository: 🤍 - In this backend master class, we’re going to learn everything about how to design, develop, and deploy a complete backend system from scratch using PostgreSQL, Golang, and Docker. TECH SCHOOL - From noob to pro 🤍 At Tech School, we believe that everyone deserves a good and free education. We create high-quality courses and tutorials in Information Technology. If you like the videos, please feel free to share and subscribe to support the channel or buy us a coffee: 🤍
Разберем, как оптимизировать общение базы данных с гошным сервисом. Пристально посмотрим на пограничную область, которой обычно не касаются ни специалисты по базам данных, ни прикладные программисты. Пройдемся от общего подхода к оптимизации до кровавых нюансов.
Продолжаем работать с PostgreSQL в Go. Сегодня напишем репозиторий, запросы в БД. Поговорим про ORM и SQL. Приятного просмотра! Часть 1. 🤍 Исходный код тут: 🤍 Поддержи выход новых видео на Патреоне! 🤍 Другие видео: Уроки по Golang. Advanced. REST API. Вебсервер. 🤍 Изучаем Python. Урок 1. Основы. Бонус: Пишем приложение на FastAPI 🤍 Изучаем Golang. Урок 1. Основы + веб-сервер в 3 строки в конце урока! 🤍 Разработка системы заметок на Python, Golang и микросервисы в 2021 году 🤍 Как стать разработчиком. Часть 1 🤍 Что такое микросервисы за 200 секунд 🤍 Что такое Apache Kafka за 200 секунд 🤍 Telegram Group: 🤍 VK: 🤍 Дружественный Golang чат: 🤍 Меня зовут Артур Карапетов и я занимаюсь всем, что связано с разработкой. Я создаю высоконагруженные информационные системы, стартапы, занимаюсь личным обучением людей в сфере разработки (программисты, аналитики, системные администраторы), также я помогаю компаниям и стартапам с обучением людей работать и повышением их квалификации, об этом можно почитать здесь: 🤍. На этом канале я выкладываю ролики на интересующие меня темы, здесь можно найти серию роликов про создание информационной системы с нуля, а также можно найти серию уроков по языкам, которые я люблю. Добро пожаловать и хорошего просмотра! #golang #урок #restapi #rest #микросервисы #microservices #jetbrains #goland #tutorial #голенг #development #howto #learnbasics #coding #programming #изучаемIT #программирование #разработка
Почему мы не используем pq в наших проектах на Go? Когда стоит использовать database/sql из стандартной библиотеки, а когда лучше работать напрямую с драйвером и почему мы не используем database/sql? Поговорили про функционал pgx позволяющий использовать LISTEN/NOTIFY, т.е. межпроцессное взаимодействие (IPC) на базе PostgreSQL. Коснулись работы с LOB и темы хранения файлов в БД. Поговорили про новую систему логгирования в pgx5 с использованием механизма трейсинга и про пул соединений.
In this video, I show you how to interact with a PostgreSQL database using Golang. This is a continuation of the gRPC introductory series, and in this video we are making our gRPC service more scalable by utilizing postgres for our backend database GitHub Repo: 🤍 part-3-json-user-data code: 🤍 Timestamps: Introduction: 00:00 Removing protojson logic: 02:29 Modifying the CreateNewUser function: 04:37 Modifying the GetUsers function: 12:21 Modifying the main function: 15:56 Running the program: 18:36 Conclusion: 23:17
Let me share with you some tips for using PostgreSQL when building Web Services! What are the pros? What are the cons? What are the best packages to use? What are the guidelines and best practices? * Previous episode: "Building Microservices in Go/Golang: PostgreSQL Database: using gorm and sqlboiler" 🤍 * Example code: 🤍 * Playlist "Golang Tools and Packages": 🤍 * Playlist "Building Microservices in Go/Golang": 🤍 = Packages used * Masterminds/squirrel * kyleconroy/sqlc Subscribe: 🤍 00:00 - Start 00:49 - Different ways to access databases 01:45 - Masterminds/squirrel 05:25 - kyleconroy/sqlc 10:10 - Demo 11:03 - Conclusion - Who am I: Hello👋🏼! I'm Mario, a Hands-on Software Architect and Lead Backend Engineer with more than 16 years of professional experience building all kinds of software including on-premise Industrial Automation Systems, Linux Accessibility Desktop and Browser Components as well as Distributed Advertising Microservices. Every week I will share with you different topics I've learned while working for small startups and large companies including the processes I've followed over the years for successfully delivering complex enterprise systems from start to end. Subscribe if you like Software Development, Software Architecture and Systems Design! Keep it up. Don't give up! #golang #microservices #postgres - Our affiliate links below Shop our favorite products → 🤍 Vlogging setup → 🤍 Get a 30 day FREE trial of Epidemic Sound → 🤍 Try Amazon Prime 30-Day FREE trial → 🤍 I love getting Cash Back and think you will too! Join for free and get $20 when you spend $20 → 🤍 Sign up to start using vidIQ to grow your YouTube channel for FREE → 🤍 - Our Vlog Channel 🤍
С этого ролика начинается реализация сортировки, фильтрации и пагинации в REST API. Пишу на Go, а СУБД PostgreSQL. Приятного просмотра! Поддержи выход новых видео на Патреоне! 🤍 Другие видео: Уроки по Golang. Advanced. REST API. Вебсервер. 🤍 Изучаем Python. Урок 1. Основы. Бонус: Пишем приложение на FastAPI 🤍 Изучаем Golang. Урок 1. Основы + веб-сервер в 3 строки в конце урока! 🤍 Разработка системы заметок на Python, Golang и микросервисы в 2021 году 🤍 Как стать разработчиком. Часть 1 🤍 Что такое микросервисы за 200 секунд 🤍 Что такое Apache Kafka за 200 секунд 🤍 Telegram Group: 🤍 VK: 🤍 Дружественный Golang чат: 🤍 Меня зовут Артур Карапетов и я занимаюсь всем, что связано с разработкой. Я создаю высоконагруженные информационные системы, стартапы, занимаюсь личным обучением людей в сфере разработки (программисты, аналитики, системные администраторы), также я помогаю компаниям и стартапам с обучением людей работать и повышением их квалификации, об этом можно почитать здесь: 🤍. На этом канале я выкладываю ролики на интересующие меня темы, здесь можно найти серию роликов про создание информационной системы с нуля, а также можно найти серию уроков по языкам, которые я люблю. Добро пожаловать и хорошего просмотра! #golang #урок #postgresql #сортировка #sorting #restapi #rest #микросервисы #microservices #jetbrains #goland #tutorial #голенг #development #howto #learnbasics #coding #programming #изучаемIT #программирование #разработка
About the talk: We will begin our journey by taking a look at a few different reasons why you would want to use a persistent data store, a relational database, and finally why you should just use Postgres most of the time. Having established what it’s used for, we will begin looking at the myriad of ways that the Go community has developed for working with databases, and Postgres in particular. About the speaker: Johan Brandhorst (🤍JohanBrandhorst) grew up and studied in Sweden but has worked in United Kingdom as a programmer since 2012 at both multi-national companies and small startups. He’s the maintainer of many big open source projects, such as the grpc-gateway and grpc-web. Having started with C/C, he now spends his time working almost exclusively with Go, presenting at conferences around the world on topics as diverse as WebAssembly and writing REST services with gRPC. #gopherconEU
In this video, we will build a simple todo application with a Go server and a React.js front-end bootstrapped with ViteJS. On the back-end, we will use Go Fibre as the webserver and on the front-end we use TypeScript. Repository: 🤍 🌎 Follow me here: Discord: 🤍 Twitter: 🤍 Facebook: 🤍 Instagram: 🤍 TikTok: 🤍 ☕ Buy me a coffee: 🤍
Roadmap по каналу - 🤍 Курс GOLANG NINJA - 🤍 Курс по разработке REST API на Go. В этом уроке разбираем поднимем базу данных Postgres в Docker-контейнере, научимся создавать и применять файлы миграций. Напишем SQL схему базы данных. Исходники: 🤍 #golang #уроки #restapi
Live coding an app with SvelteJS, Go, CockroachDB, and Juju Charms in Python. Sometimes Linux desktop app or WordPress plugin development too. Always Developing Playlist:- 🤍 Before starting every work day, I do half an hour of noodling on side projects, making sure to keep them moving forward, albeit slowly. Working on these side projects is how I learn new programming languages, frameworks and technologies. Chances are I'll fail miserably each and every day, so at the very least you can take comfort in seeing a so-called senior developer fumbling through some development with little success. Blog:- 🤍 Twitter:- 🤍 Tech Used: Svelte:- 🤍 Go:- 🤍 CockroachDB:- 🤍 Juju:- 🤍
Subscribe at 🤍 to get notified of new episodes. In this episode of Scaling Postgres, we discuss select for update, the pgx framework to generate extensions, cool additions to Postgres 14 and full-text search. Links for this episode: 🤍 🤍 🤍 🤍 🤍 🤍 🤍 🤍 🤍 🤍 🤍
Подписывайтесь на наш канал здесь и в телеграмм 🤍 чтобы быть в курсе будущих митапов и не пропускать полезные доклады! Валентин Хомутенко, бэкенд-инженер в Авито «У разработчиков на разных стеках сложилось разное отношение к ORM: где-то без них не работают вообще, где-то используют лишь иногда. В Go тема использования ORM стала известным холиваром и часто можно услышать, что «ORM не нужны». Доклад — это попытка разобраться, почему так сложилось, и действительно ли у Go просто свой путь в работе с базами данных». Если вы тоже хотите поделиться экспертизой с сообществом, ещё есть возможность стать спикером. Пишите на andy🤍evrone.com, он поможет составить хороший доклад. Ну а обсудить услышанное можно будет прямо в ходе митапа, спикеры будут отвечать на вопросы в комментариях. Чтобы присоединиться, скорее регистрируйтесь здесь. 00:00 - Введение 00:30 - ORM в других языках 02:10 - ORM в Go 04:12 - Почему люди пользуются ORM? 06:40 - Без ORM пишут крутаны, которые хорошо знают SQL 08:49 - В маленьких командах не нужен ORM 10:36 - ORM это всегда проблемы с производительностью 12:34 - Для сложных запросов ORM мешает 13:46 - ORM не нужен, если не тестировать реальную БД 15:34 - Микросервисы можно писать и без ORM 16:54 - Нет готовой базы знаний и лучших практик 18:26 - Никто не хочет изобретать велосипед 19:55 - Гоферы просто страдают без ORM и ничего не могут с этим сделать? 20:31 - database/sql 21:29 - sqlx 22:09 - squirrel 22:46 - migrate 24:20 - Есть ли нормальные ORM в Go? 25:06 - gorm 26:33 - reform 27:38 - ent 28:16 - pop 29:25 - bun (go-pg) 30:20 - Заключение
In this video, we'll learn how to properly handle Postgres DB errors with pgx driver. - Tech School's home page: 🤍 - Join us on Discord: 🤍 - Get the course on Udemy: 🤍 - Buy us a coffee: 🤍 - Full series playlist: 🤍 - GitHub repository: 🤍 - In this backend master class, we’re going to learn everything about how to design, develop, and deploy a complete backend system from scratch using PostgreSQL, Golang, and Docker. TECH SCHOOL - From noob to pro 🤍 At Tech School, we believe that everyone deserves a good and free education. We create high-quality courses and tutorials in Information Technology. If you like the videos, please feel free to share and subscribe to support the channel or buy us a coffee: 🤍
Simple example of Connecting to database Postgresql using Golang. Inserting data into table Its simple web based example for beginners Recommended IDE : Visual Studio Code Please install package go get github.com/lib/pq Other Install: Postgresql can be downloaded : 🤍 PGAdmin: 🤍 Please do Like, Share and Subscribe to my Channel. #postgresql #golang #database #golangExample #GolangPostgreSQL #GolangBeginners #PGAdmin
Let me share with you another tips when building microservices in Go! Repository Pattern, Domain and Application Services; and Dependency Injection * Blog post: 🤍 * Previous episode: "Building Microservices in Go/Golang: Project Layout": 🤍 * "Building Microservices in Go/Golang: Accessing PostgreSQL Databases - Part 3": 🤍 * Example code: 🤍 * Playlist "Building Microservices in Go/Golang": 🤍 * Playlist "Go/Golang Tools and Packages": 🤍 Subscribe: 🤍 00:00 - Start 00:15 - Agenda 01:12 - Repository Pattern 04:27 - Application Services 06:08 - Dependency Injection 08:20 - Conclusion - Who am I: Hello👋🏼! I'm Mario, a Hands-on Software Architect and Lead Backend Engineer with more than 16 years of professional experience building all kinds of software including on-premise Industrial Automation Systems, Linux Accessibility Desktop and Browser Components as well as Distributed Advertising Microservices. Every week I will share with you different topics I've learned while working for small startups and large companies including the processes I've followed over the years for successfully delivering complex enterprise systems from start to end. Subscribe if you like Software Development, Software Architecture and Systems Design! Keep it up. Don't give up! #golang #microservices #ddd - Our affiliate links below Shop our favorite products → 🤍 Vlogging setup → 🤍 Get a 30 day FREE trial of Epidemic Sound → 🤍 Try Amazon Prime 30-Day FREE trial → 🤍 I love getting Cash Back and think you will too! Join for free and get $20 when you spend $20 → 🤍 Sign up to start using vidIQ to grow your YouTube channel for FREE → 🤍 - Our Vlog Channel 🤍
Welcome! Let's learn about Go Modules! What is a "Go Module"? A module is a collection of Go packages stored in a file tree with a "go.mod" file at its root. This file defines: * Module path: indicates how our package will be imported by our users, and * Dependency Requirements, indicate the packages we depend on. "Dependency Requirements" not only covers the actual packages but also ways to "Replace" or "Exclude" them, using the corresponding directives: * Replace: allows replacing a version of a dependency with another one, for example in cases where local deployment is still happening or when working for forked versions; and * Exclude: allows excluding a version of a dependency from use, for example in cases those versions include security issues or bugs. "Go Modules" were introduced in Go 1.11 and enabled by default in Go 1.16, they use "Semantic Versioning" (SemVer) as the main versioning system, were versions are defined using three numbers: Major.Minor.Patch. The Go toolchain allows interacting with Modules via the "mod" command, but not only that other commands like "get" or "build" are also compatible with Go Modules, the most used commands are: * "go mod init" to initialize a module, for example "go mod init github.com/MarioCarrion/example-pkg" * "go get _package/version_🤍_specific-version_" go get packages with specific version, for example "go get github.com/jackc/pgx/v4🤍v4.10.1" * "go get" can be used to upgrade or downgrade as well, for example to downgrade: "go get github.com/jackc/pgx/v4🤍v4.10.0" or update to latest "go get -u github.com/jackc/pgx/v4" * "go mod tidy" to remove unused dependencies. - * "The Go Blog: Using Go Modules" 🤍 Real life examples of versioning Go Modules: * Using module path: 🤍 * Using branches: 🤍 Tools: * 🤍 Update outdated Go dependencies interactively * 🤍 Automated Semantic Import Versioning Upgrades - * Previous Episode: "Golang Tutorial: Context package: Cancellations, Deadlines and Request-scoped values": 🤍 * Blog: 🤍 * Playlist "Learning Golang": 🤍 * Playlist "Building Microservices in Go/Golang": 🤍 * Playlist "Golang Tools and Packages": 🤍 * Playlist "Testing in Go": 🤍 00:00 - Start 00:08 - What is a Go Module? 01:09 - go.mod? require? replace? exclude? 02:12 - go.mod in real life 02:36 - go.mod indirect? 03:06 - go.sum 03:58 - Versioning Go Modules: Path or Branch 05:29 - Demo, go mod init 08:59 - Module upgrade and downgrade 13:18 - Requesting available updates 14:19 - Versioning: Real life examples 15:26 - Go Modules: Conclusion and parting words - Who am I: Hello👋🏼! I'm Mario, a Hands-on Software Architect and Lead Backend Engineer with more than 16 years of professional experience building all kinds of software including on-premise Industrial Automation Systems, Linux Accessibility Desktop and Browser Components as well as Distributed Advertising Microservices. Every week I will share with you different topics I've learned while working for small startups and large companies including the processes I've followed over the years for successfully delivering complex enterprise systems from start to end. Subscribe if you like Software Development, Software Architecture and Systems Design! Keep it up. Don't give up! #golang #tutorial #programming - Our affiliate links below Shop our favorite products → 🤍 Vlogging setup → 🤍 Get a 30 day FREE trial of Epidemic Sound → 🤍 Try Amazon Prime 30-Day FREE trial → 🤍 I love getting Cash Back and think you will too! Join for free and get $20 when you spend $20 → 🤍 Sign up to start using vidIQ to grow your YouTube channel for FREE → 🤍 - Our Vlog Channel 🤍
Roadmap по каналу - 🤍 Курс GOLANG NINJA - 🤍 Курс по разработке REST API на Go. В этом уроке мы научимся подключаться к Postgres из приложения, а также работать с файлами конфигураций. Познакомимся с библиотекой sqlx. Исходники: 🤍 #golang #уроки #restapi
Securing database access to prevent unauthorized access and SQL injections is something we must consider when interacting with databases. The standard library provides a way to prevent SQL injection but because we have the freedom to create queries using string concatenation we could be in trouble when doing it incorrectly. What is SQL Injection? "SQL injection is a code injection technique used to attack data-driven applications, in which malicious SQL statements are inserted into an entry field for execution." (Quote from Wikipedia: 🤍 How can we prevent SQL injection? By using Prepared Statements, identified by placeholders (Like $1, $2 in PostgreSQL and ? in MySQL); in those cases were creating queries with dynamic conditions instead of using manual string concatenation I recommend using a query builders, like "Masterminds/squirrel", this way the placeholders are still honored but the actual call is made by the database driver. Using Permissions to Secure databases To secure databases on the backend can also create dedicated database users with their corresponding access, basically two users one for CRUD actions (Insert, Select, Update and Delete) that happens to only access the Write/Read cluster, and another one for R actions (Select) with access to the Read-Only cluster. Relevant Links * Security Considerations to take when using GORM: 🤍 * PostgreSQL driver and toolkit for Go: 🤍 * Fluent SQL generation for golang: 🤍 * "Golang Microservices: PostgreSQL: gorm and sqlboiler" 🤍 * "Golang Microservices: PostgreSQL: sqlx, pgx and sql" 🤍 * "Golang Microservices: PostgreSQL via sqlc, squirrel" 🤍 * Example code: 🤍 * Previous Episode: "Software Architecture in Golang: Security - Dependencies": 🤍 All Go/Golang video series covered * Playlist "Software Architecture in Go/Golang": 🤍 * Playlist "Learning Go/Golang": 🤍 * Playlist "Learning Go/Golang Concurrency Patterns" 🤍 * Playlist "Building Microservices in Go/Golang": 🤍 * Playlist "Go/Golang Tools and Packages": 🤍 * Playlist "Testing in Go/Golang": 🤍 00:00 - Start 00:26 - What is SQL Injection? Go/Golang Example 05:03 - Example of Preventing SQL Injection in Go/Golang 07:34 - Example building Dynamic Queries and also Preventing SQL Injection in Go/Golang 12:11 - Using Permissions to Secure Databases 14:35 - Conclusion - Who am I: Hello👋🏼! I'm Mario, a Hands-on Software Architect and Lead Backend Engineer with more than 16 years of professional experience building all kinds of software including on-premise Industrial Automation Systems, Linux Accessibility Desktop and Browser Components as well as Distributed Advertising Microservices. Every week I will share with you different topics I've learned while working for small startups and large companies including the processes I've followed over the years for successfully delivering complex enterprise systems from start to end. Subscribe if you like Software Development, Software Architecture and Systems Design! Keep it up. Don't give up! #golang #security #softwarearchitecture - Our affiliate links below Shop our Amazon favorites → 🤍 Shop my IG feed on my LIKEtoKNOWit (LTK) page → 🤍 Shop Top Deals and Featured Offers at Best Buy → 🤍 Get a 30 day FREE Trial of Epidemic Sound → 🤍 Try Amazon Prime 30-day FREE Trial → 🤍 I love getting Cash Back and think you will too! Join for FREE and get $30 when you spend $30 → 🤍 - Our Vlog Channel 🤍
Let's learn about Bulk Insert in Relational Databases using Go/Golang specifically using the "mysql" package. This episode covers the concrete methods defined in "mysql" to deal with Bulk Inserts, specifically using the LOAD INTO command via the two functions available in the package: ■ RegisterLocalFile and ■ RegisterReaderHandler Relevant links ■ Example code: 🤍 ■ Relational Databases - Bulk Insert with PostgreSQL: 🤍 ■ Learning Go/Golang : 🤍 ■ Learning Relational Databases in Go/Golang: 🤍 ■ A MySQL-Driver for Go's database/sql package: 🤍 All Go/Golang Playlists ■ Software Architecture in Go/Golang: 🤍 ■ Building Microservices in Go/Golang: 🤍 ■ Go/Golang Tools and Packages: 🤍 ■ Learning Concurrency Patterns in Go/Golang: 🤍 ■ Testing in Go/Golang: 🤍 Socials ■ 🤍 ■ 🤍 ■ 🤍 00:00 - Start 00:13 - Bulk Insert in Go/Golang using MySQL using RegisterLocalFile 06:20 - Bulk Insert in Go/Golang using MySQL using RegisterReaderHandler 11:54 - Conclusions - Who am I: Hello👋🏼! I'm Mario, a Hands-on Software Architect and Lead Backend Engineer with more than 16 years of professional experience building all kinds of software including on-premise Industrial Automation Systems, Linux Accessibility Desktop and Browser Components as well as Distributed Advertising Microservices. Every week I will share with you different topics I've learned while working for small startups and large companies including the processes I've followed over the years for successfully delivering complex enterprise systems from start to end. Subscribe if you like Software Development, Software Architecture and Systems Design! Keep it up. Don't give up! #golang #tutorial #databases = Our Vlog Channel 🤍 = Our affiliate links below ■ My Amazon Storefront: 🤍 ■ Shop my IG posts on my shopLTK page: 🤍 ■ Vlog camera: Sony RX100 VII 🤍 ■ Other vlog cameras and gear: 🤍 ■ Shop through my links to support the channel: 🤍 ■ Get a 30 day FREE Trial of Epidemic Sound: 🤍 ■ Join Rakuten for FREE and get $30 when you spend $30: 🤍 DISCLAIMER: Some of the links shared in the description are affiliate links. As a member of these affiliate programs, I earn a small commission from your purchases at no additional cost to you. I appreciate your support! 💖
Url: 🤍 Author: jackc Repo: pgx Description: PostgreSQL driver and toolkit for Go Starred: 4193 Forked: 414 Top Languages: Go 99.5% | Shell 0.5% Total commits: 1912 Initial commit: Sat Mar 30 12:06:27 2013 -0700 Total number of files: 64 Total number of lines: 18147
In this video, we'll look at the database/sql package in Go, and how to use this package to work with SQL relational databases. We will look at how to connect to a PostgreSQL database running in a Docker container, and how to create tables, insert data and query data using the Go database package. We'll look at the difference between three database functions: - db.Exec() - db.Query() - db.QueryRow() And will outline when to use each. ☕️ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲: To support the channel and encourage new videos, please consider buying me a coffee here: 🤍 📌 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀: 00:00 Intro 00:49 Setting up PostgreSQL Docker container 04:20 Connecting to Postgres from Go app with sql.Open 09:36 Creating table in database with CREATE TABLE SQL 14:28 Inserting data into table with Go 22:02 Querying single row with db.QueryRow() 26:21 Querying for multiple rows with db.Query() 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮: 📖 Blog: 🤍 👾 Github: 🤍 🐦 Twitter: 🤍 📚 𝗙𝘂𝗿𝘁𝗵𝗲𝗿 𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗮𝗻𝗱 𝗶𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻: Go database/sql package: 🤍 Go Postgres driver pq: 🤍 #golang #webdevelopment #database #sql
Made a video on YouTube about the recently reported increase in malware. I've been predicting since about 2015 that Go's unique compiled artifact footprint, relatively changing compilation techniques, combined with being statically linked, cross-platform compilable, C compatible, and drop-dead "simpler C syntax" would have malware coders to pleased they would eventually make it their favorite for all malware, well it seems that is what has happened. It's hit mainstream press now because major malware and ransomware is popping up all over now in Go. So if you want to attack or understand attackers, Go is your darling (and always probably should have been). I will laugh out loud when the Metasploit database has to figure out how to take in all the new Go code that's popping up. The CVE people only add a new category for the language in 2019 (or something). The hackers are fucking loving this. • 🤍 • 🤍 • 🤍 Thanks sponsors, subs, and followers: • GitHub: 🤍 • Twitch: 🤍 • Twitter: 🤍 • Discord: 🤍 See 🤍 for stream schedule.
.svg){kind=small}
![[Backend #66] Switch DB driver from lib/pq to pgx](https://i.ytimg.com/vi/m9gYy5U0edQ/mqdefault.jpg "[Backend #66] Switch DB driver from lib/pq to pgx")
![[Backend #65] Config sqlc version 2 for Go and Postgres](https://i.ytimg.com/vi/FfXE245HZB4/mqdefault.jpg "[Backend #65] Config sqlc version 2 for Go and Postgres")
![[REST API на Golang #4] Запуск Postgres в Docker. Файлы миграций. Конфигурации приложения.](https://i.ytimg.com/vi/xJ7NC8xeJus/mqdefault.jpg "[REST API на Golang #4] Запуск Postgres в Docker. Файлы миграций. Конфигурации приложения.")
![[Backend #67] How to handle DB errors with PGX driver](https://i.ytimg.com/vi/9vf3zxrMUgw/mqdefault.jpg "[Backend #67] How to handle DB errors with PGX driver")
![[REST API на Golang #5] Подключение к БД из приложения. Переменные окружения. Библиотека sqlx](https://i.ytimg.com/vi/sDsAf3gikpQ/mqdefault.jpg "[REST API на Golang #5] Подключение к БД из приложения. Переменные окружения. Библиотека sqlx")
