Geekflare is supported by our audience. We may earn affiliate commissions from buying links on this site.
Database
Total 73 articles
Explore the latest technology, best practices, and strategies for designing, implementing, and optimizing database systems along with tutorials on MySQL, MongoDB, MariaDB, NoSQL, and other database management systems.
If you lived through the early 90s and 2000s, the chances are that you’re already familiar with the LAMP web development stack. Which, in short, stood for Linux, Apache, MySQL, and PHP/Python/Perl. Most web projects were being built using the specific stack alone.
This article talks about the frequently used queries and commands of MongoDB used by developers and DBA in their day to day development and operation life.
Sharding is a process of splitting up the large scale of data sets into a chunk of smaller data sets across multiple MongoDB instances in a distributed environment.
SQL injection is one of the popular attack techniques, but it is not just in SQL (relational database) but also in NoSQL (non-SQL or also known as a non-relational database).
PostgreSQL is one of the popular, cross-platform, open-source object-relational database systems which is robust, high performing, and reliable with a strong community.
For an application to have a good performance, you need a powerful application server, a guaranteed and ample bandwidth, and a well-done programming job. But there is one aspect that is not always taken into account and that usually has a big impact on the performance of any application: the database design.
With the emergence and growth of Cloud computing, traditional computing services are now shifting to Cloud platforms. Cloud Providers have embraced the trend, making Cloud databases the new rave.
All organizations use databases to some extent, whether to handle simple, low-volume data sets, such as a secretary’s address book, or large Big Data repositories for strategic information analysis.
RDS, an abbreviation for Relational Database Service, is an offering from AWS. Amazon Web Services RDS makes development more accessible, convenient, and on-the-fly with pay-as-you-go pricing.
Learn how PostgreSQL and MySQL fair in the database creation, utilization, and maintenance spectrum by reading this ultimate PostgreSQL vs. MySQL guide.
Looking for an open-source and free SQL manipulating tool for remote and on-site work? You can try out the most popular tool in the market that is MySQL Workbench.
Graph databases store highly-connected dense data and process queries efficiently. But, do you know when to use which graph database? Read to learn more.
OLAP and OLTP are both online processing systems but are slightly different. While OLAP is an analytical processing system, OLTP is a transactional processing system.