Home » Archives for December 24, 2021

Skip to content
Thnk And Grow

Let's Do It!

  • facebook.com
  • twitter.com
  • t.me
  • instagram.com
  • youtube.com
Subscribe
  • Home
  • All topicsExplore the newest trends in technology. Learn about AI, software, gadgets, and cybersecurity. Stay up to date in the fast-paced world of tech.
  • RubyExplore essential Ruby tips and tricks to enhance your coding skills. Find recommendations for useful gems and learn how to benchmark performance effectively.
    • Ruby on RailsExplore easy Ruby on Rails tutorials for all levels. Learn how to use MVC, Active Record, and other Rails features to build strong and fast web apps.
    • GemsExplore essential Ruby gems that can boost your development. Learn how to install and use them effectively with tips, guides, and best practices.
  • Architecture & DesignDiscover cutting-edge architecture and design ideas. Explore innovative projects, modern interior design trends, sustainable architecture, and creative design solutions to inspire your next project.
    • AWS
    • DockerExplore essential Docker tutorials and resources. Find helpful tips, best practices, and tools to master containerization and improve your deployment workflow.
    • SecurityThe Security category focuses on best practices, tools, and frameworks essential for protecting applications, data, and infrastructure in an increasingly digital world
  • DatabaseFind easy-to-follow guides on database SQL, NoSQL, PostgreSQL, and MySQL. Learn how to make databases that are fast and work well. Get tips to improve your skills. [caption id="attachment_1057" align="alignnone" width="747"] database[/caption]
    • PostgreSQLExplore comprehensive PostgreSQL tutorials and resources. Find helpful tips, best practices, and performance benchmarks to enhance your database skills.
    • MySQLDiscover essential database guides covering SQL, NoSQL, and best practices. Get tips and performance benchmarks to improve your data management skills.
    • NoSQLDiscover essential database guides covering SQL, NoSQL, and best practices. Get tips and performance benchmarks to improve your data management skills.
  • NodeJSExplore beginner to advanced tutorials on JavaScript and TypeScript. Find helpful tips, best practices, and tools to create powerful web applications.
    • Javascript/TypescriptLearn JavaScript and TypeScript with easy guides. Discover tips, best practices, and tools to build efficient web applications quickly.
    • Realtime
      • Socket.IO
  • OthersDive into a variety of tech topics in our ‘Others’ category. Discover helpful guides, tips, and resources on web development, design, and more.
    • Interview Question
    • TipsStay updated with the latest technology insights and innovations at thinkandgrow.com. Explore articles, tutorials, and news to enhance your tech knowledge and stay ahead.
    • Notes
    • Tools
  • About us
  • facebook.com
  • twitter.com
  • t.me
  • instagram.com
  • youtube.com
  • Home
  • All topicsExplore the newest trends in technology. Learn about AI, software, gadgets, and cybersecurity. Stay up to date in the fast-paced world of tech.
  • RubyExplore essential Ruby tips and tricks to enhance your coding skills. Find recommendations for useful gems and learn how to benchmark performance effectively.
    • Ruby on RailsExplore easy Ruby on Rails tutorials for all levels. Learn how to use MVC, Active Record, and other Rails features to build strong and fast web apps.
    • GemsExplore essential Ruby gems that can boost your development. Learn how to install and use them effectively with tips, guides, and best practices.
  • Architecture & DesignDiscover cutting-edge architecture and design ideas. Explore innovative projects, modern interior design trends, sustainable architecture, and creative design solutions to inspire your next project.
    • AWS
    • DockerExplore essential Docker tutorials and resources. Find helpful tips, best practices, and tools to master containerization and improve your deployment workflow.
    • SecurityThe Security category focuses on best practices, tools, and frameworks essential for protecting applications, data, and infrastructure in an increasingly digital world
  • DatabaseFind easy-to-follow guides on database SQL, NoSQL, PostgreSQL, and MySQL. Learn how to make databases that are fast and work well. Get tips to improve your skills. [caption id="attachment_1057" align="alignnone" width="747"] database[/caption]
    • PostgreSQLExplore comprehensive PostgreSQL tutorials and resources. Find helpful tips, best practices, and performance benchmarks to enhance your database skills.
    • MySQLDiscover essential database guides covering SQL, NoSQL, and best practices. Get tips and performance benchmarks to improve your data management skills.
    • NoSQLDiscover essential database guides covering SQL, NoSQL, and best practices. Get tips and performance benchmarks to improve your data management skills.
  • NodeJSExplore beginner to advanced tutorials on JavaScript and TypeScript. Find helpful tips, best practices, and tools to create powerful web applications.
    • Javascript/TypescriptLearn JavaScript and TypeScript with easy guides. Discover tips, best practices, and tools to build efficient web applications quickly.
    • Realtime
      • Socket.IO
  • OthersDive into a variety of tech topics in our ‘Others’ category. Discover helpful guides, tips, and resources on web development, design, and more.
    • Interview Question
    • TipsStay updated with the latest technology insights and innovations at thinkandgrow.com. Explore articles, tutorials, and news to enhance your tech knowledge and stay ahead.
    • Notes
    • Tools
  • About us
Subscribe

Day: December 24, 2021

Home » Archives for December 24, 2021
How to get `previous` and `next` record in PostgreSQL/ MySQL with LAG and LEAD function

How to get `previous` and `next` record in PostgreSQL/ MySQL with LAG and LEAD function

Posted by By Lê Hoàng Tâm December 24, 2021Posted inAll topicsTags: Postgresql, Rails
1 bài toán cơ bản, nhỏ nhỏ lúc làm việc thôi. Đề bài là: Tìm record tiếp theo và record trước. Database dùng UUID vẫn có thể sử dụng được.…
Read More
Recent Posts
  • Optimizing GROUP BY in MySQL: Insights from Real-Life Query Analysis December 24, 2024
  • AWS Backup: Simplify Your Cloud Data Protection December 21, 2024
  • 10 Advanced JavaScript Tricks Every Developer Should Master December 20, 2024
  • Step-by-Step Guide: Setting Up Git and Shell Aliases on All Operating Systems December 13, 2024
  • Laragon: The Ultimate Lightweight Development Environment for Windows December 12, 2024
Categories
  • All topics 95
  • Architecture & Design 31
  • AWS 14
  • Database 18
  • Design patterns 6
  • Docker 6
  • Gems 1
  • Generation 2
  • Interview Question 11
  • Javascript/Typescript 10
  • MySQL 11
  • NodeJS 14
  • NoSQL 5
  • Notes 3
  • Others 4
  • PostgreSQL 10
  • Realtime 2
  • Ruby 19
  • Ruby on Rails 10
  • Security 4
  • Socket.IO 3
  • Tips 32
  • Tools 5
Post You Might Like
Posted inAll topics Database MySQL
Optimizing GROUP BY in MySQL: Insights from Real-Life Query Analysis
Posted by By Lê Hoàng Tâm December 24, 2024
Posted inAll topics Architecture & Design AWS
AWS Backup: Simplify Your Cloud Data Protection
Posted by By Lê Hoàng Tâm December 21, 2024
JS-tricks
Posted inJavascript/Typescript NodeJS Tips
10 Advanced JavaScript Tricks Every Developer Should Master
Posted by By Hoài Nhớ December 20, 2024
Git alias
Posted inInterview Question Tips Tools
Step-by-Step Guide: Setting Up Git and Shell Aliases on All Operating Systems
Posted by By Hoài Nhớ December 13, 2024

AWS AWS SQS Backend Backend Performance compare Database Database Questions Deploy Deployment DKIM record DNS Record Docker Docker swarm Interview Questions iRedAdmin iRedMail Javascipt javascript MailGun Mail Server Multiple Threads mysql NextJS Nginx optimize database optimize performance Optimize Queries optimize query Popular Postgresql Rails Realtime Application redis RESTFul API Route53 ruby Ruby on rails S3 Security SPF record SQS Tech Interview Tips Traefik Web Development

  • December 2024
  • November 2024
  • October 2024
  • September 2024
  • August 2024
  • June 2024
  • May 2024
  • April 2024
  • August 2023
  • May 2023
  • April 2023
  • April 2022
  • January 2022
  • December 2021
  • October 2021
  • September 2021
  • June 2021
  • May 2021
  • April 2021
December 2021
SMTWTFS
 1234
567891011
12131415161718
19202122232425
262728293031 
« Oct   Jan »
Copyright 2024 — Thnk And Grow. All rights reserved. Bloglo WordPress Theme
Scroll to Top