Click here to Skip to main content

Articles by Arctype SQL (Technical Blogs: 12)

Technical Blogs: 12

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating:

No articles have been posted.

Average blogs rating: 4.31

Database Development
MySQL	Search MySQL Like Google Using Match and Full-Text Search [Technical Blog] 1 Apr 2021 Updated: 1 Apr 2021 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 9,322 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. How to use full text search and the match keyword to find a string in every table in a MySQL database
	Collaborative Filtering in MySQL: A Tutorial [Technical Blog] 22 Apr 2021 Updated: 22 Apr 2021 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 4,100 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. Simple examples of collaborative filtering with fundamental logic behind all of these systems boiling down to same principles used here
	Using Cursors and for Loops in MySQL [Technical Blog] 19 Nov 2021 Updated: 19 Nov 2021 Rating: 1.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 20,353 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Learn how to write a MySQL cursor or a MySQL loop
PostgreSQL	A Complete Guide to UUIDs in PostgreSQL [Technical Blog] 24 Mar 2021 Updated: 24 Mar 2021 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 10,202 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Universally Unique IDs (UUIDs) use random numbers to create unique IDs. UUIDs use more storage, but they provide a good solution for distributed databases and security.
	Postgres Notify for Real Time Dashboards [Technical Blog] 24 Mar 2021 Updated: 24 Mar 2021 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 7,331 Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. Using pg_notify in Postgres alongside the NOTIFY and LISTEN syntax is all that's needed to build a real time updating dashboard
	Anatomy of a PostgreSQL Query Plan [Technical Blog] 9 Apr 2021 Updated: 9 Apr 2021 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 4,571 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. Explanation of how a query gets execution and understanding the EXPLAIN command
	Need a UUID Generator for Postgres? Here are Two Ways to Set One Up. [Technical Blog] 1 Dec 2021 Updated: 1 Dec 2021 Rating: 4.50/5 Votes: 2 Popularity: 1.35 Licence: CPOL Views: 13,436 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. In this article, you'll learn about Postgres UUIDs and how to generate them with examples from two different modules.
Redis	Choose the Right Model: Comparing Relational, Document, and Graph Databases [Technical Blog] 24 Nov 2021 Updated: 24 Nov 2021 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 5,560 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. There are three major types of database models in use today. Learn about their differences and what applications they are good for.
DevOps
Deployment	Deploy and Manage PostgreSQL on Kubernetes [Technical Blog] 31 Mar 2021 Updated: 31 Mar 2021 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 9,042 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. Easily deploy PostgreSQL pod in Kubernetes
General Programming
Architecture	Data Replication for DBMS using the Commit Log [Technical Blog] 24 Jul 2021 Updated: 24 Jul 2021 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 3,060 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. As a business expands, the need to ethically leverage data is not a luxury anymore, but a necessity.
Programming Languages
SQL	Decoding Django Sessions in PostgreSQL [Technical Blog] 24 Mar 2021 Updated: 24 Mar 2021 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 4,031 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. When solving a problem that requires you to link a user's session data to their actual user object, Postgres comes in handy.
	How I Learned to Stop Worrying and Love NULL in SQL [Technical Blog] 22 Apr 2021 Updated: 22 Apr 2021 Rating: 4.67/5 Votes: 2 Popularity: 1.40 Licence: CPOL Views: 8,431 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Write your query in a way to overcome the limitations of NULL rather than avoid using it.

Average tips rating:

No tips have been posted.

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

Arctype SQL

Technical Writer Arctype

United States

Download our free SQL editor at https://www.arctype.com

This is a Organisation

3 members