databases – WindowsTechs.com

SQL Server Essentials: What Is a Relational Database?

Posted on March 12, 2024 by Michael Otey

SQL Server is a relational database. But what is a relational database exactly? Mike Otey, our resident SQL Server expert, explains in this article. What is a relational database? A relational database is a type of data storage mechanism that organizes data into tables where each table consists of rows and columns. It is typically…

The post SQL Server Essentials: What Is a Relational Database? appeared first on Petri IT Knowledgebase.

Continue reading SQL Server Essentials: What Is a Relational Database?→

OAuth2: Storing temp values in session vs database

Posted on February 23, 2024 by Ryan

I have implemented OAuth2 for a web app. Everything is stored in the session, and I am switching this to a database. This makes sense for the subject and roles, but it also includes the temporary values like state and the redirect uri that… Continue reading OAuth2: Storing temp values in session vs database→

OAuth2: Storing temp values in session vs database

Posted on February 23, 2024 by Ryan

Is it safe to store database credentials as plain text in the configuration file?

Posted on January 28, 2024 by Lester

Some services like ejabberd, nginx for authenticating using a database, and dovecot requires providing the database password as plain text in the configuration file. Is it safe to store MariaDB password as plain text provided that processe… Continue reading Is it safe to store database credentials as plain text in the configuration file?→

How to keep membership in sync in a multi tenant architecture with per tenant database?

Posted on January 28, 2024 by sam

I’m working on a project where we aim to have a separate database for each tenant. In our setup, there is a central database (and API) containing a "users" table that stores usernames and passwords for all users. Additionally, th… Continue reading How to keep membership in sync in a multi tenant architecture with per tenant database?→

Risk for a public RDS database on AWS

Posted on January 7, 2024 by JVanced

I have a RDS database on a VPC which is public with a password.
I have some lambda functions (that are not in a VPC) that communicates with this database. To be able to do that I had to modify the security group of my database that allows … Continue reading Risk for a public RDS database on AWS→

What Is a Graph Database? Use Cases, Benefits and More

Posted on December 21, 2023 by Collins Ayuya

Graph databases are uniquely structured to handle complex data relationships. Learn how they work, the types of graph databases and some of the top graph database software. Continue reading What Is a Graph Database? Use Cases, Benefits and More→

How to ensure privacy of my codebase while keeping data on client premises?

Posted on December 13, 2023 by finstats

I have created a data science model pipeline in Python which ingests some data (user transactions) and then runs some models to generate a report. The models that I have created are proprietary and so far I have only been working on a samp… Continue reading How to ensure privacy of my codebase while keeping data on client premises?→

Understanding Secondary Log Hard Disk Impact on Write Speed and Data Integrity After Power Outage

Posted on December 3, 2023 by cricket900

I’ve recently come across the notion that a secondary log hard disk can be employed to enhance write operation speed in a database system. I find this concept intriguing but am struggling to grasp the mechanics behind it. Could someone she… Continue reading Understanding Secondary Log Hard Disk Impact on Write Speed and Data Integrity After Power Outage→

Is it safe to keep a JDBC SQLite URI in source code?

Posted on December 1, 2023 by Setu Kumar Basak

If I commit the name of SQLite database in the JDBC SQLite URI in the source code like below, is it possible for an attacker to exploit the URI?
Should I replace the name of the SQLite db with code to retrieve it from environmental variabl… Continue reading Is it safe to keep a JDBC SQLite URI in source code?→