15,914,608 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Artificial Intelligence
Artificial Intelligence
Neural Networks
Machine Learning
Deep Learning
ML.Net
Big Data
Data Science
Tensorflow
ChatGPT
Internet of Things
Internet of Things
Arduino
Edge Device
Raspberry-Pi
Wearables
IoT Edge
Industrial IoT
DevOps
DevOps
Agile
Automation
Continuous Build
Continuous Delivery
Continuous Deployment
Continuous Integration
Deployment
Git
Installation
Integration Testing
Load Testing
Quality Assurance
TFS
Unit Testing
Testing
Containers
Containers
Docker
Kubernetes
Virtual Machine
High Performance Computing
High Performance Computing
GPU
Parallel Processing
Parallelization
Vectorization
Hosted Services
Hosted Services
AWS
Cordova
ExtJS
Google Cloud
Microservices
PhoneGap
Serverless
Storage
Web Hosting
WordPress
Azure
Security
Security
Blockchain
Cryptography
Encryption
Identity
Identity Server
Web Development
Web Development
Blazor
CSS3
Flask
HTML5
Kestrel
LESS
Nginx
Node.js
React
SCSS
Spring
Vue.js
ASP.NET
CSS
Apache
HTML
IIS
XHTML
Mobile Apps
Mobile Apps
Flutter
Ionic
iOS
Nativescript
React Native
Xamarin
Windows Mobile
Android
Desktop Programming
Desktop Programming
Cocoa
Electron
QT
Universal Windows Platform
X11
Windows Forms
ATL
MFC
Swing
Win32
WTL
WPF
XAML
System
Database Development
Database Development
Data Visualization
Elasticsearch
Lucene
MariaDB
MongoDB
NoSQL
PostgreSQL
Redis
MySQL
SQL Server
Productivity Apps and Services
Productivity Apps and Services
LibreOffice
OpenOffice
Sharepoint
Team Communication Tools
Biztalk
Microsoft Office
SAP
Game Development
Game Development
Doom
Kinect
Playstation 4
Playstation 5
Unity
Unreal
XBox
Multimedia
Multimedia
Audio
Image Processing
Video
Audio Video
DirectX
GDI
GDI+
OpenGL
General Programming
General Programming
Algorithms
Compression
Computational Geometry
Emulation
Exceptions
File
Internet
Localization
Memory Management
Optimization
Parser
Performance
Regular Expressions
Sorting
State Machines
Architecture
Design / Graphics
Printing
String
Threads
Usability
Programming Languages
Programming Languages
ASM
Bash
Basic
COBOL
Dart
Go
Haskell
Kotlin
Lua
Pascal
R
Razor
Rust
Scala
Swift
Typescript
Objective C
Visual Basic
VBScript
C++
C#
F#
FORTRAN
Java
Javascript
Perl
Python
Ruby
SQL
PHP
PowerShell
XML
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,662
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,240
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: 21,879
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,682
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,502
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,671
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: 14,009
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,701
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,573
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,130
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,161
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: 9,740
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