Gang Of Coders
Home
About Us
Contact Us
All Database Solutions on Gang of Coders
Total of 983 Database Solutions
What is the difference between "INNER JOIN" and "OUTER JOIN"?
Sql
Database
Join
Inner Join
Outer Join
How can I list the tables in a SQLite database file that was opened with ATTACH?
Sql
Database
Sqlite
Metadata
Laravel Database Schema, Nullable Foreign
Php
Mysql
Database
Laravel
Microservices with shared database? using multiple ORM's?
Database
Database Design
Orm
Architecture
Microservices
Android Room Persistence library and Kotlin
Database
Kotlin
Kapt
Android Room
Alternatives to Toad
Database
Oracle
Database - Data Versioning
Database
Database Design
Versioning
Does dropping a table in MySQL also drop the indexes?
Mysql
Database
Indexing
Sql Drop
Is it a good idea to use an integer column for storing US ZIP codes in a database?
Database
Database Design
Types
Street Address
Postal Code
How do I drop a table from SQLite3 in DJango?
Database
Django
Sqlite
Changing Table Engine in MySQL
Mysql
Database
Innodb
Myisam
Using Solr search index as a database - is this "wrong"?
Java
Mysql
Database
Solr
What is the difference between logical data model and conceptual data model?
Database
Database Design
PostgreSQL database service
Windows
Database
Postgresql
How do I create a HashCode in .net (c#) for a string that is safe to store in a database?
C#
.Net
Database
Hashcode
Gethashcode
How to migrate a PostgreSQL database into a SQLServer one?
Sql Server
Database
Postgresql
Migration
Synchronous database queries with Node.js
Database
node.js
Synchronous
Change primary key column in SQL Server
Sql
Sql Server
Database
Shared Hosting
row-level trigger vs statement-level trigger
Sql
Database
Generate insert script for selected records?
Sql
Database
Sql Server-2008
Why is "close existing connections to destination database" grayed out on SQL Server 2012 Management Studio?
Sql Server
Database
Sql Server-2012
Ssms
Database Restore
How to get a count of number of documents in a collection with Cloud Firestore
Database
Firebase
Google Cloud-Firestore
Concepts of backref and back_populate in SQLalchemy?
Python
Database
Sqlalchemy
What is the best way to implement soft deletion?
Sql
Database
Database Design
Backup
How should I store a GUID in Oracle?
Database
Oracle
Guid
Are MongoDB and CouchDB perfect substitutes?
Mongodb
Couchdb
Database
Selecting rows where remainder (modulo) is 1 after division by 2?
Sql
Database
Select
Where Clause
Modulus
How can I modify the size of column in a MySQL table?
Mysql
Database
Alter Table
How can I put a database under git (version control)?
Database
Git
Version Control
Postgresql
How to schedule a stored procedure in MySQL
Mysql
Database
Stored Procedures
Mysql Routines
H2 database error: Database may be already in use: "Locked by another process"
Java
Database
H2
What is difference between foreign key and reference key?
Sql
Database
Foreign Keys
Error in contrasts when defining a linear model in R
Database
R
Statistics
How to fix a collation conflict in a SQL Server query?
Sql Server
Database
Collation
Postgres Error: More than one row returned by a subquery used as an expression
Sql
Database
Postgresql
Subquery
Dblink
Mongoose: Schema vs Model?
node.js
Mongodb
Postgresql
Mongoose
Database
Adding a new value to an existing ENUM Type
Database
Postgresql
Enums
Database on a personal github page
Database
Github
cx_Oracle: How do I iterate over a result set?
Python
Sql
Database
Oracle
Cx Oracle
Best way to understand complex SQL statements?
Sql
Database
What are the limitations to SQL Server Compact? (Or - how does one choose a database to use on MS platforms?)
Sql Server
Database
Visual Studio-2008
Sql Server-Ce
Test User Data (Fake Data)
Database
Testing
Test Data
How do I shrink my SQL Server Database?
Sql Server
Database
Shrink
Msde2000
Hibernate and no PK
Java
Database
Hibernate
Jpa
Difference between stored procedures and user defined functions
Sql
Database
Stored Procedures
How to check if a database exists in SQL Server?
Sql Server
Database
Tsql
Is there any boolean type in Oracle databases?
Sql
Database
Oracle
Boolean
Sqldatatypes
What's faster, SELECT DISTINCT or GROUP BY in MySQL?
Mysql
Sql
Database
Group By
Distinct
At what point is it worth using a database?
C++
Sql
Database
Qt
User Interface
How can I set default storage engine used by MySQL?
Mysql
Database
Innodb
Variable table name in sqlite
Python
Database
Sqlite
Online databases for trying out Oracle SQL queries?
Sql
Database
Oracle
When to use MongoDB
Mysql
Mongodb
Database Design
Relational Database
Database
Why is a primary-foreign key relation required when we can join without it?
Sql
Database
How to use an user variables in MySQL LIKE clause?
Mysql
Sql
Database
How do you query DynamoDB?
Database
Nosql
Amazon Dynamodb
Android SQLite Example
Android
Database
Sqlite
Sqliteopenhelper
How to substring a MySQL table column
Mysql
Database
Inserting a record into a table with a column declared with the SERIAL function
Database
Postgresql
Display all views on oracle database
Database
Oracle
View
Oracle Sqldeveloper
Laravel : Migrations & Seeding for production data
Php
Database
Laravel
Laravel 4
Database Migration
What is the difference between "wait-die" and "wound-wait" deadlock prevention algorithms?
Database
Deadlock
Database Deadlocks
UNIQUE constraint failed: sqlite database : android
Java
Android
Database
Sqlite
Unique Constraint
The Next-gen Databases
Sql
Database
Nosql
Non Relational-Database
Postgresql: how to create table only if it does not already exist?
Sql
Database
Postgresql
What is the difference between JOIN and UNION?
Sql
Database
Join
Union
Why do we need a temporal database?
Database
Temporal Database
Laying out a database schema for a calendar application
Database
Schema
Calendar
Normalization
How to store articles or other large texts in a database
Xml
Database
Postgres Alter Column Integer to Boolean
Database
Postgresql
Why are foreign keys more used in theory than in practice?
Sql
Database
Foreign Keys
Should I write table and column names ALWAYS lower case?
Database
Database Design
Using a database table as a queue
Sql
Database
Sql Server-2008
Queue
What is the difference between a lock and a latch in the context of concurrent access to a database?
Database
Concurrency
Locking
How to enter special characters like "&" in oracle database?
Sql
Database
Oracle
Oracle Sqldeveloper
phpMyAdmin Removing an index
Database
Indexing
Phpmyadmin
Unique
AWS RDS instance upgrade down time
Mysql
Database
Amazon Web-Services
Amazon Rds
Clone MySQL database
Mysql
Database
Mysqldump
Improving OFFSET performance in PostgreSQL
Database
Postgresql
Query Optimization
django set DateTimeField to server's current time
Python
Database
Django
What does ON UPDATE RESTRICT do?
Mysql
Database
Database Design
Vendor code 17002 to connect to SQLDeveloper
Database
Connect
Oracle Sqldeveloper
What is a database index?
Database
Indexing
Check if list contains item from other list in EntityFramework
C#
Database
Linq
Entity Framework
A SQLiteConnection object for database was leaked! Please fix your application
Java
Android
Database
Sqlite
SELECT and UPDATE multiple records in oriento / orientjs and transaction in waterline
Database
sails.js
Orientdb
Waterline
Sails Orientdb
Sharing databases between projects within Intellij
Database
Intellij Idea
Sharing
Projects
SQLite Performance Benchmark -- why is :memory: so slow...only 1.5X as fast as disk?
Python
Database
Sqlite
Memory
Benchmarking
Ideas on database design for capturing audit trails
Database
Database Design
Audit
Using Rails Migration on different database than standard "production" or "development"
Ruby on-Rails
Ruby
Database
Migration
Explaining why "Just add another column to the DB" is a bad idea, to non programmers
Sql
Database
Architecture
Communication
Normalization
How to count number of occurrences for all different values in database column?
Sql
Database
Postgresql
Alternatives to Entity-Attribute-Value (EAV)?
Database
Database Design
Data Structures
Data Modeling
Entity Attribute-Value
Can table columns with a Foreign Key be NULL?
Sql
Mysql
Database
Foreign Keys
Migrate database from Postgres to MySQL
Mysql
Database
Postgresql
Know relationships between all the tables of database in SQL Server
Sql
Sql Server
Database
Tsql
Display dynamic image from database or remote source with p:graphicImage and StreamedContent
Database
Image
Jsf
Jsf 2
Primefaces
Where does H2's Embedded Databases Store the data?
Java
Database
Jdbc
H2
Embedded Database
selecting rows with id from another table
Mysql
Sql
Database
General-purpose databases that never delete or update data in-place
Database
Immutability
Survey
Database Versioning
Datomic
Easy way to view postgresql dump files?
Database
Postgresql 9.1
Pg Dump
Import postgres database without roles
Sql
Database
Postgresql
Import
Psql
How to persist a graph data structure in a relational database?
Database
Graph
Relational Database
PostgreSQL error when trying to create an extension
Database
Postgresql
List database tables with SQLAlchemy
Python
Database
Sqlalchemy
PostgreSQL Get a random datetime/timestamp between two datetime/timestamp
Sql
Database
Postgresql
Datetime
Timestamp
Does MySQL index foreign key columns automatically?
Mysql
Database
Indexing
Handling very large data with mysql
Mysql
Database
Performance
Indexing
Partitioning
Postgresql Docker role does not exist
Database
Postgresql
Docker
Xml or Sqlite, When to drop Xml for a Database?
Xml
Database
Best Practice for Designing User Roles and Permission System?
Mysql
Database
Database Design
Why restrict the length of a password?
Database
Security
Web Applications
Passwords
Create SQL Server CE database file programmatically
C#
.Net
Sql Server
Database
Sql Server-Ce
Multiple databases in Rails
Ruby on-Rails
Database
Activerecord
What is the difference between graph-based databases and object-oriented databases?
Database
Db4o
Neo4j
Graph Databases
Object Oriented-Database
Database design for a social networking site
Database
Database Design
Social Networking
Is it good database design to have admin users in the same table as front-end users?
Sql
Sql Server
Database
Database Design
Data Modeling
update one table with data from another
Sql
Database
How do I update an android sqlite database column value to null using ContentValues?
Android
Sql
Database
Sqlite
Displaying a Table in Django from Database
Django
Database
create table with sequence.nextval in oracle
Sql
Database
Oracle
Plsql
Why do SQL databases use a write-ahead log over a command log?
Sql
Database
Logging
Transactions
Voltdb
Maximum concurrent connections to MySQL
Mysql
Database
Create a view with ORDER BY clause
Sql Server
Database
Tsql
View
Sql Server-2008-R2
Show values from a MySQL database table inside a HTML table on a webpage
Php
Mysql
Database
Html Table
Rails checking if a record exists in database
Ruby on-Rails
Database
Null
Is Microsoft dropping support for SDF database files in Visual Studio?
Database
Visual Studio
Sql Server-Ce
Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)
Php
Mysql
Database
Phpmyadmin
Localhost
using sqlalchemy to load csv file into a database
Python
Database
Sqlalchemy
Scaling Postgres horizontally
Database
Postgresql
Horizontal Scaling
AWS: Why does my RDS instance keep starting after I turned it off?
Database
Amazon Web-Services
Aws Lambda
How to resolve ORA-011033: ORACLE initialization or shutdown in progress
Database
Oracle
Is writing server log files to a database a good idea?
Database
Logging
Log Analysis
Log Files
What is the difference between Unique Key and Index with IsUnique=Yes?
Sql Server
Database
What's the point of using Amazon SimpleDB?
Database
Amazon Web-Services
Amazon Simpledb
Data Warehouse Considerations: When and Why?
Database
Database Design
Data Warehouse
What is the most clever and easy approach to sync data between multiple entities?
Database
Algorithm
Mobile
Synchronization
Can a database table be without a primary key?
Mysql
Sql Server
Database
How to store MySQL query results in another Table?
Mysql
Sql
Database
How to do database unit testing?
Database
Unit Testing
Database Testing
Extreme wait-time when taking a SQL Server database offline
Database
Sql Server-2005
Performance
Why do you create a View in a database?
Sql
Sql Server
Database
Tsql
What is the difference between a primary key and a index key
Database
Primary Key
What column type should be used to store serialized data in a mysql db?
Mysql
Database
SQL Server giving logins(users) db_owner access to database
Sql
Sql Server
Database
django OneToOne reverse access
Database
Django
One to-One
How to visualize database tables in postgresql using pgAdmin?
Sql
Database
Postgresql
Pgadmin
Database partitioning - Horizontal vs Vertical - Difference between Normalization and Row Splitting?
Database
Database Design
Database Performance
Sharding
Database Partitioning
How can I import a .sql file into my Heroku postgres database?
Database
Postgresql
Heroku
Import
Version of SQLite used in Android?
Database
Android
Sqlite
Schema
Migration
What are database normal forms and can you give examples?
Database
Database Design
Database Normalization
Does it make sense to dockerize (containerize) databases?
Database
Virtualization
Docker
mongoose difference of findOneAndUpdate and update
Database
Mongodb
Mongoose
Sql Update
Remove double quotes from the return of a function in PostgreSQL
Json
Database
Postgresql
Function
Entity Framework core - Contains is case sensitive or case insensitive?
C#
Database
Postgresql
Linq
Entity Framework-Core
Compare a date string to datetime in SQL Server?
Sql Server
Database
Tsql
Datetime
Why is SELECT * considered harmful?
Sql
Database
How to list all databases in the mongo shell?
Database
Mongodb
Mongodb Query
How can I do a BEFORE UPDATED trigger with sql server?
Sql
Sql Server
Database
Triggers
Sql Server-Express
First name, middle name, last name. Why not Full Name?
Database
Database Design
User Interface
Database structure and source control - best practice
Database
Version Control
How to store an array into mysql?
Php
Mysql
Database
What are the benefits of using database cursor?
Sql
Database
Database Cursor
Right way to close WPF GUI application: GetCurrentProcess().Kill(), Environment.Exit(0) or this.Shutdown()
C#
Wpf
Database
Exception Handling
Close Application
Max length for client ip address
Sql
Database
Database Design
Drop default constraint on a column in TSQL
Sql
Sql Server
Database
Tsql
data block size in HDFS, why 64MB?
Database
Hadoop
Mapreduce
Block
Hdfs
SQL Server 2008 R2 Stuck in Single User Mode
Sql
Sql Server
Database
Sql Server-2008
Database Deployment
What is the difference between single and double quotes in SQL?
Sql
Database
Quotes
difference between primary key and unique key
Mysql
Sql
Database
Primary Key
Unique Key
What is the datatype bytea and when would I use it?
Database
Postgresql
Definition
Bytea
How to drop softDeletes from a table in a migration
Php
Database
Laravel
Laravel Migrations
Which version of PostgreSQL am I running?
Linux
Database
Postgresql
How do I list all the columns in a table?
Sql
Mysql
Sql Server
Database
Oracle
What is Hash and Range Primary Key?
Hash
Amazon Dynamodb
Primary Key
Database
Nosql
How do I interpret precision and scale of a number in a database?
Sql
Database
Decimal
Scale
Precision
Backup/Restore a dockerized PostgreSQL database
Database
Postgresql
Backup
Docker
What's the best practice for primary keys in tables?
Sql
Sql Server
Database
Relational
What does ON [PRIMARY] mean?
Sql
Sql Server
Database
Database Design
CAP theorem - Availability and Partition Tolerance
Database
Nosql
Consistency
Availability
SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
Sql
Sql Server
Database
Sql Server-2005
Custom Data-Type
Storing JSON in database vs. having a new column for each key
Mysql
Sql
Sql Server
Database
Optimization
Correct use of transactions in SQL Server
Sql
Sql Server
Database
Tsql
Transactions
Entity Framework and Connection Pooling
.Net
Database
Entity Framework
ado.net
Connection Pooling
What's the difference between MyISAM and InnoDB?
Mysql
Database
Innodb
Myisam
What's wrong with foreign keys?
Database
Database Design
Foreign Keys
Referential Integrity
Data Integrity
How to compare dates in datetime fields in Postgresql?
Sql
Database
Postgresql
Date
Is there a .NET/C# wrapper for SQLite?
C#
.Net
Database
Sqlite
How to randomly select rows in SQL?
Sql
Database
Random
Good PHP ORM Library?
Php
Database
Orm
Need to list all triggers in SQL Server database with table name and table's schema
Sql
Sql Server
Database
Tsql
Triggers
Is the primary key automatically indexed in MySQL?
Mysql
Database
Indexing
Key
Advantages and disadvantages of GUID / UUID database keys
Database
Guid
Uuid
Count the occurrences of DISTINCT values
Mysql
Sql
Database
Distinct
Django Model - Case-insensitive Query / Filtering
Database
Django
Django Models
Filtering
Fastest way to count exact number of rows in a very large table?
Sql
Database
How to cache data in a MVC application
asp.net Mvc
Database
Caching
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
Sql
Sql Server
Database
Foreign Keys
How do I quickly rename a MySQL database (change schema name)?
Mysql
Database
Innodb
Rename
Find rows that have the same value on a column in MySQL
Sql
Mysql
Database
Create a new database with MySQL Workbench
Mysql
Database
Mysql Workbench
First-time database design: am I overengineering?
Mysql
Database
Database Design
Schema
Database Normalization
MySQL dump by query
Sql
Mysql
Database
Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
Php
Mysql
Database
Best way to check for "empty or null value"
Sql
Database
Postgresql
Null
Coalesce
Safely remove migration In Laravel
Php
Database
Laravel
Artisan Migrate
Use email address as primary key?
Sql
Database
Database Design
Postgresql
What did MongoDB not being ACID compliant before v4 really mean?
Sql
Mongodb
Acid
Database
Nosql
Best way to work with dates in Android SQLite
Android
Sql
Database
Sqlite
Date
Can I add a UNIQUE constraint to a PostgreSQL table, after it's already created?
Sql
Database
Postgresql
Indexing
Unique Constraint
Table is marked as crashed and should be repaired
Mysql
Database
Wordpress
Optimise PostgreSQL for fast testing
Sql
Database
Performance
Postgresql
Database Tuning
Foreign key constraints: When to use ON UPDATE and ON DELETE
Mysql
Sql
Database
Foreign Keys
phpMyAdmin - Error > Incorrect format parameter?
Database
Mysql
What is an ORM, how does it work, and how should I use one?
Database
Orm
Language Agnostic
How to create user for a db in postgresql?
Database
Postgresql
Authentication
Connection
Query to list number of records in each table in a database
Sql Server
Database
When NOT to use Cassandra?
Database
Rdbms
Nosql
Cassandra
MySQL: Cloning a MySQL database on the same MySql instance
Mysql
Database
Copy
Clone
Difference between set with {merge: true} and update
Database
Firebase
Google Cloud-Firestore
JOIN queries vs multiple queries
Mysql
Database
Join
Query Optimization
Explanation of BASE terminology
Database
Nosql
Terminology
Definition
Base Db
How do I get the "id" after INSERT into MySQL database with Python?
Python
Mysql
Database
Location of my.cnf file on macOS
Mysql
Database
Macos
H2 in-memory database. Table not found
Java
Database
H2
What are best practices for multi-language database design?
Sql
Database
Database Design
What resources exist for Database performance-tuning?
Mysql
Sql Server
Database
Oracle
Postgresql
What is the difference between Non-Repeatable Read and Phantom Read?
Database
Oracle
Transactions
Isolation Level
Transaction Isolation
What is best tool to compare two SQL Server databases (schema and data)?
Sql
Sql Server
Database
Compare
Possibility of duplicate Mongo ObjectId's being generated in two different collections?
Mongodb
Database
Nosql
Connect to a heroku database with pgadmin
Database
Postgresql
Heroku
Pgadmin
How to configure postgresql for the first time?
Linux
Database
Postgresql
Configuration
What should every developer know about databases?
Database
Language Agnostic
Database Design
How do I create a MongoDB dump of my database?
Database
Mongodb
Database Dump
delete_all vs destroy_all?
Ruby on-Rails
Ruby
Database
Activerecord
"where 1=1" statement
Mysql
Sql
Database
Strings as Primary Keys in SQL Database
Sql
Database
Database Design
String
Primary Key
The object 'DF__*' is dependent on column '*' - Changing int to double
Sql
Sql Server
Database
Entity Framework
Entity Framework-4
Fastest hash for non-cryptographic uses?
Php
Database
Security
Hash
MyISAM versus InnoDB
Mysql
Database
Performance
Innodb
Myisam
Store images in a MongoDB database
Mongodb
Database
What is sharding and why is it important?
Database
Terminology
Generate table relationship diagram from existing schema (SQL Server)
Sql Server
Database
Diagram
How can I get column names from a table in Oracle?
Sql
Database
Oracle
How to use mongoimport to import csv
Database
Mongodb
Csv
Import
Mongoimport
Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc
Sql
Database
Why should I use document based database instead of relational database?
Database
Couchdb
Relational
Non Relational-Database
How do I move a redis database from one server to another?
Database
Redis
Data Migration
Database Migration
Copy values from one column to another in the same table
Mysql
Database
How to check if a table exists in a given schema
Sql
Database
Postgresql
Information Schema
Search Path
How does the HyperLogLog algorithm work?
Database
Algorithm
Math
Data Structures
Hyperloglog
How to find the mysql data directory from command line in windows
Mysql
Database
Linux
Windows
Command Line
How to check which locks are held on a table
Sql
Sql Server
Database
Performance
Sql Server-2005
Is there a good reason I see VARCHAR(255) used so often (as opposed to another length)?
Database
Database Design
Types
Varchar
Generate the ERD for an existing database
Database
Postgresql
Erd
Reset identity seed after deleting records in SQL Server
Sql
Sql Server
Database
Sql Server-2008
Azure Sql-Database
Database, Table and Column Naming Conventions?
Database
Database Design
Language Agnostic
Naming Conventions
What's the difference between identifying and non-identifying relationships?
Database
Database Design
Data Modeling
Identifying Relationship
Import SQL file into mysql
Mysql
Sql
Database
Windows
Import
How do I automatically update a timestamp in PostgreSQL
Database
Postgresql
Timestamp
Difference between database and schema
Sql Server
Database
Sql Server-2005
Database Schema
Binary Data in MySQL
Mysql
Database
Binary Data
Data Storage
What is the difference between a schema and a table and a database?
Database
Schema
Definition
Database Table
How to find out the MySQL root password
Mysql
Database
Maximum number of records in a MySQL database table
Mysql
Database
Limit
Database Table
Is it possible to specify the schema when connecting to postgres with JDBC?
Java
Database
Postgresql
Jdbc
Database Schema
Storing time-series data, relational or non?
Database
Nosql
Relational Database
Time Series
Non Relational-Database
Easiest way to copy a table from one database to another?
Mysql
Database
How SID is different from Service name in Oracle tnsnames.ora
Database
Oracle
Service
Administration
Sid
How do I reset a sequence in Oracle?
Sql
Database
Oracle
Sequence
List all sequences in a Postgres db 8.1 with SQL
Sql
Database
Postgresql
Migration
Sequences
What scalability problems have you encountered using a NoSQL data store?
Database
Nosql
Key Value-Store
Graph Databases
Distributed Database
Is it better to use multiple databases with one schema each, or one database with multiple schemas?
Database
Database Design
Postgresql
Database Permissions
Throw an error preventing a table update in a MySQL trigger
Mysql
Database
Triggers
Surrogate vs. natural/business keys
Database
Database Design
Primary Key
Key
Storing money in a decimal column - what precision and scale?
Sql
Database
Database Design
Currency
Find duplicate records in MongoDB
Mongodb
Aggregation Framework
Database
How to do an INNER JOIN on multiple columns
Sql
Database
What is a good choice of database for a small .NET application?
Mongodb
Sqlite
Vistadb
Eloquera
Database
How can I tell where mongoDB is storing data? (its not in the default /data/db!)
Mongodb
Directory
Database
What's the difference between findAndModify and update in MongoDB?
Database
Mongodb
Sql Update
How to think in data stores instead of databases?
Database
Google App-Engine
Google Cloud-Platform
Google Cloud-Datastore
What is database pooling?
Database
Database Connection
Connection Pooling
Right query to get the current number of connections in a PostgreSQL DB
Sql
Database
Postgresql
Dbconnection
PDO get the last ID inserted
Php
Mysql
Database
Pdo
How to empty a redis database?
Database
Nosql
Redis
Postgres: clear entire database before re-creating / re-populating from bash script
Database
Backup
Postgresql
Relational table naming convention
Database
Database Design
Coding Style
Naming Conventions
Relational Database
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints
C#
asp.net
Sql
Database
Informix
IN vs OR in the SQL WHERE Clause
Sql
Database
Bulk insert with SQLAlchemy ORM
Python
Mysql
Database
Orm
Sqlalchemy
SQL, Postgres OIDs, What are they and why are they useful?
Sql
Database
Performance
Postgresql
Difference between scaling horizontally and vertically for databases
Database
Database Design
Nosql
Scalability
How to do a batch insert in MySQL
Mysql
Sql
Database
Insert
Is there any NoSQL data store that is ACID compliant?
Database
Nosql
Acid
Elastic search, multiple indexes vs one index and types for different data sets?
Database
Search
Elasticsearch
Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
Sql
Database
Postgresql
Jdbc
Ddl
Foreign Key naming scheme
Database
Naming Conventions
Foreign Keys
What is the difference between an ORM and an ODM?
Database
Orm
Odm
How do ACID and database transactions work?
Database
Transactions
Acid
Pros and Cons of SQLite and Shared Preferences
Android
Database
Sqlite
Sharedpreferences
Data Storage
Difference between 3NF and BCNF in simple terms (must be able to explain to an 8-year old)
Database
Relational Database
Database Normalization
3nf
What does GRANT USAGE ON SCHEMA do exactly?
Database
Postgresql
Schema
Sql Grant
Database Permissions
Implementing Comments and Likes in database
Mysql
Database
Design Patterns
Database Design
What is NoSQL, how does it work, and what benefits does it provide?
Database
Nosql
Multiple Indexes vs Multi-Column Indexes
Sql Server
Database
Indexing
MongoDB vs. Cassandra
Mongodb
Database Design
Cassandra
Database
What's wrong with nullable columns in composite primary keys?
Database
Database Design
What's the recommended way to connect to MySQL from Go?
Mysql
Database
Go
Difference between Fact table and Dimension table?
Database
Data Warehouse
Business Intelligence
Fact Table
How to unit test an object with database queries
Database
Unit Testing
Exposing database IDs - security risk?
Database
Security
What is the difference between a database and a data warehouse?
Database
Data Warehouse
How do I find out my MySQL URL, host, port and username?
Java
Mysql
Database
Jdbc
Database Connection
How do I alter the position of a column in a PostgreSQL database table?
Sql
Database
Postgresql
Alter Table
How to get english language word database?
Database
Words
Reset the database (purge all), then seed a database
Ruby on-Rails
Database
Seeding
Store query result in a variable using in PL/pgSQL
Database
Postgresql
Stored Procedures
Plpgsql
Postgresql 9.1
Mongoose and multiple database in single node.js project
Javascript
node.js
Mongodb
Mongoose
Database
'IF' in 'SELECT' statement - choose output value based on column values
Mysql
Sql
Database
SQL query to find record with ID not in another table
Sql
Database
Postgresql
What is the best place for storing uploaded images, SQL database or disk file system?
Database
Filesystems
Image Uploading
Binaryfiles
What should I name a table that maps two tables together?
Sql
Database
Database Design
Naming Conventions
Data Modeling
What is a database transaction?
Database
Concurrency
Transactions
Theory
Failover
How to write a simple database engine
Sql
Database
Theory
Database Engine
Copying data from one SQLite database to another
Database
Sqlite
NoSql vs Relational database
Database
Database Design
Nosql
Relational Database
Rdbms
How can I avoid concurrency problems when using SQLite on Android?
Android
Database
Sqlite
Database cluster and load balancing
Database
Load Balancing
Cluster Computing
Database Agnostic
A migration to add unique constraint to a combination of columns
Ruby on-Rails
Database
What does 'COLLATE SQL_Latin1_General_CP1_CI_AS' do?
Sql Server
Database
Tsql
Collation
Is there a way to set an "expiry" time, after which a data entry is automatically deleted in PostgreSQL?
Database
Postgresql
Ttl
Can you get DB username, pw, database name in Rails?
Ruby on-Rails
Ruby
Database
Activerecord
Environment
SQL ON DELETE CASCADE, Which Way Does the Deletion Occur?
Sql
Database
Database Design
Cascade
Relation
What is the difference between SQL and MySQL?
Mysql
Sql
Database
How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
Mysql
Database
Database Replication
Select last N rows from MySQL
Mysql
Database
Is mongodb running?
Mongodb
Unix
Database
Nosql
How to design a database for User Defined Fields?
Sql
Database
Database Design
User Defined-Fields
Is there a MySQL option/feature to track history of changes to records?
Mysql
Database
Sequelize.js: how to use migrations and sync
Database
node.js
Database Migration
sequelize.js
SQLAlchemy: cascade delete
Python
Database
Sqlalchemy
MySQL: ignore errors when importing?
Mysql
Database
Import
How to drop columns using Rails migration
Ruby on-Rails
Ruby
Database
Activerecord
Rails Migrations
How to get size of mysql database?
Mysql
Database
Difference between rake db:migrate db:reset and db:schema:load
Ruby on-Rails
Ruby
Database
Rake
Solutions for INSERT OR UPDATE on SQL Server
Sql
Sql Server
Database
Insert
Upsert
Swapping column values in MySQL
Mysql
Database
How can I add comments in MySQL?
Mysql
Database
Comments
Where does mongodb stand in the CAP theorem?
Mongodb
Cap Theorem
Database
Nosql
What is the most efficient way to store tags in a database?
Database
Database Design
Tags
Data Modeling
Tagging
Deleting all records in a database table
Ruby on-Rails
Ruby
Database
Ruby on-Rails-3
How does database indexing work?
Sql
Database
Performance
Indexing
Database Indexes
Using git repository as a database backend
Database
Git
Database Performance
Database Replication
Document Database
Why is it not advisable to have the database and web server on the same machine?
Database
Security
Networking
Infrastructure
Hardware Infrastructure
What is the difference between CHARACTER VARYING and VARCHAR in PostgreSQL?
Database
Postgresql
Varchar
Varying
How to Get True Size of MySQL Database?
Mysql
Database
Size
Byte
Storage
Good tool to visualise database schema?
Mysql
Database
Database Design
Schema
Visualization
Export Postgresql table data using pgAdmin
Database
Postgresql
Export
Pgadmin
How to move a model between two Django apps (Django 1.7)
Python
Mysql
Database
Django
Schema Migration
LINQ to SQL Left Outer Join
.Net
Database
Linq
Linq to-Sql
Lightweight Javascript DB for use in Node.js
Javascript
Database
Key Value-Store
Primary key or Unique index?
Sql
Database
Database Design
Reorder / reset auto increment primary key
Mysql
Database
What is an MDF file?
Mdf
Sql Server
Database
File
mysql: see all open connections to a given database?
Mysql
Database
How can I check if a View exists in a Database?
Sql
Sql Server
Database
Stored Procedures
View
Entity Framework .Remove() vs. .DeleteObject()
C#
Database
Entity Framework
Orm
How to find largest objects in a SQL Server database?
Sql Server
Database
Storing Data in MySQL as JSON
Mysql
Json
Database
Ruby on Rails: How do I add a not null constraint to an existing column using a migration?
Ruby on-Rails
Database
Migration
Constraints
Notnull
The backend version is not supported to design database diagrams or tables
Sql
Sql Server
Database
Ssms
How do you debug MySQL stored procedures?
Mysql
Database
Debugging
Stored Procedures
SQL how to increase or decrease one for a int column in one command
Database
What is this JavaScript "require"?
Javascript
Database
Postgresql
node.js
Why do we need entity objects?
Sql
Database
Orm
Entities
Importing a CSV file into a sqlite3 database table using Python
Python
Database
Csv
Sqlite
Ways to save enums in database
Java
Database
Enums
Physical vs. logical (hard vs. soft) delete of database record?
Sql
Database
Database Design
Soft Delete
Hard Delete
Entity Attribute Value Database vs. strict Relational Model Ecommerce
Sql
Database
Design Patterns
Entity Attribute-Value
Key Value
Two single-column indexes vs one two-column index in MySQL?
Sql
Mysql
Database
Performance
Indexing
How can I schedule a job to run a SQL query daily?
Sql
Sql Server
Database
Sql Server-2008
Sql Job
Good reasons NOT to use a relational database?
Sql
Database
Nosql
How to work with Git branches and Rails migrations
Ruby on-Rails
Database
Git
Skip certain tables with mysqldump
Sql
Mysql
Database
Mysqldump
In Firebase, is there a way to get the number of children of a node without loading all the node data?
Database
Firebase
Count
How can I edit a view using phpMyAdmin 3.2.4?
Mysql
Database
Phpmyadmin
In MySQL, how to copy the content of one table to another table within the same database?
Sql
Mysql
Database
How do I view the SQLite database on an Android device?
Android
Database
Sqlite
Adb
Mechanisms for tracking DB schema changes
Php
Mysql
Database
Svn
Migration
What is the recommended way to delete a large number of items from DynamoDB?
Database
Nosql
Amazon Web-Services
Cloud
Amazon Dynamodb
Cast int to varchar
Mysql
Sql
Database
Casting
Mariadb
When to use MyISAM and InnoDB?
Mysql
Database
Database Schema
Django error - matching query does not exist
Database
Django
Django Models
Production
Are soft deletes a good idea?
Sql
Database
Database Design
Data Modeling
Soft Delete
Microservices and database joins
Database
Integration
Microservices
Store pictures as files or in the database like MSSQL for a web app?
asp.net
Database
What are the use cases of Graph-based Databases (http://neo4j.org/)?
Database
Neo4j
Graph Databases
SQLAlchemy: how to filter date field?
Python
Sql
Database
Orm
Sqlalchemy
Is it fine to have foreign key as primary key?
Database
Foreign Keys
Primary Key
Set default value of an integer column in SQLite
Database
Sqlite
How to implement a many-to-many relationship in PostgreSQL?
Sql
Database
Postgresql
Database Design
Many to-Many
Native JSON support in MYSQL 5.7 : what are the pros and cons of JSON data type in MYSQL?
Mysql
Json
Database
Database Normalization
How do I kill all the processes in Mysql "show processlist"?
Mysql
Database
Difference between partition key, composite key and clustering key in Cassandra?
Database
Cassandra
Cql
How do I restore a dump file from mysqldump?
Mysql
Sql
Database
Authentication plugin 'caching_sha2_password' cannot be loaded
Mysql
Database
Mysql Workbench
Mysql 8.0
There is already an object named in the database
Database
Entity Framework
Ef Code-First
Entity Framework-6
Entity Framework-Migrations
What's the difference between MySQLdb, mysqlclient and MySQL connector/Python?
Python
Mysql
Database
Mysql Python
Mysql Connector
Database: To delete or not to delete records
Database
Database Design
Master-master vs master-slave database architecture?
Database
Are Databases and Functional Programming at odds?
Sql
Database
Functional Programming
Lisp
How to COUNT rows within EntityFramework without loading contents?
C#
Database
Entity Framework
proper hibernate annotation for byte[]
Java
Database
Hibernate
Postgresql
Blob
What are the differences between the BLOB and TEXT datatypes in MySQL?
Mysql
Database
Text
Blob
Flat file databases
Php
Sql
Database
Flat File
what is the difference between GROUP BY and ORDER BY in sql
Sql
Mysql
Database
Do you use source control for your database items?
Database
Version Control
Is there a version control system for database structure changes?
Sql
Database
Oracle
Version Control
Are foreign keys really necessary in a database design?
Database
Oracle
Foreign Keys
How do you check what version of SQL Server for a database using TSQL?
Sql Server
Database
Tsql
Enable binary mode while restoring a Database from an SQL dump
Mysql
Database
Mysqldump
Database Restore
Favourite performance tuning tricks
Sql
Sql Server
Database
Performance
Database Design for Revisions?
Sql
Database
Database Design
Versioning
Import SQL dump into PostgreSQL database
Database
Postgresql
Why should you use an ORM?
Database
Orm
Automatically create an Enum based on values in a database lookup table?
C#
Database
Dynamic
Enums
How do I rename a column in a database table using SQL?
Sql
Database
Rename
A beginner's guide to SQL database design
Sql
Database
Database Design
Scalability
MySQL check if a table exists without throwing an exception
Php
Mysql
Pdo
Database
Change from SQLite to PostgreSQL in a fresh Rails project
Ruby on-Rails
Database
Sqlite
Postgresql
Heroku
How to backup sqlite database?
Database
Sqlite
Backup
Best design for a changelog / auditing database table?
Database
Database Design
Audit
Maximum execution time in phpMyadmin
Php
Mysql
Database
Xampp
Execution Time
Postgres could not connect to server
Ruby on-Rails
Database
Postgresql
Macos
Homebrew
How to find a table having a specific column in postgresql
Sql
Database
Postgresql
Postgresql 9.1
Best practices for storing postal addresses in a database (RDBMS)?
Database
Database Design
Types
Street Address
Postal Code
Unable to cast object of type 'System.DBNull' to type 'System.String`
C#
asp.net
Database
Null
MySQL 'create schema' and 'create database' - Is there any difference
Sql
Mysql
Oracle
Jdbc
Database
How do I change db schema to dbo
Sql
Sql Server
Database
Sql Server-2008
Schema
How do you query for "is not null" in Mongo?
Mongodb
Database
Nosql
What is the difference between Left, Right, Outer and Inner Joins?
Sql
Database
Join
How many database indexes is too many?
Database
Oracle
Database Design
Querying data by joining two tables in two database on different servers
Sql
Sql Server
Database
Sql Server-2005
Sql Server-2008
AWS MySQL RDS vs AWS DynamoDB
Mysql
Database
Amazon Web-Services
Amazon Dynamodb
"The transaction log for database is full due to 'LOG_BACKUP'" in a shared host
asp.net
Sql Server
asp.net Mvc
Database
Common MySQL fields and their appropriate data types
Mysql
Database
Types
Maximum MIMEType Length when storing type in DB
Database
Mime Types
SQL Server Script to create a new user
Sql
Sql Server
Database
Android: upgrading DB version and adding new table
Android
Database
Sqlite
Why do I need Transaction in Hibernate for read-only operations?
Java
Database
Hibernate
Transactions
Database Connection
How to reset db in Django? I get a command 'reset' not found error
Python
Database
Django
Reset
OperationalError: database is locked
Python
Django
Database
Sqlite
Locked
Elasticsearch query to return all records
Database
Elasticsearch
Query String
Elasticsearch Dsl
How to shrink/purge ibdata1 file in MySQL
Mysql
Database
Innodb
Multiple columns index when using the declarative ORM extension of sqlalchemy
Python
Database
Orm
Indexing
Sqlalchemy
How do I make case-insensitive queries on Mongodb?
Regex
Mongodb
Database
View's SELECT contains a subquery in the FROM clause
Mysql
Sql
Database
Views
Retrieve database or any other file from the Internal Storage using run-as
Android
Database
Android Sqlite
Adb
Internal Storage
SQL Server: Get data for only the past year
Sql
Sql Server
Database
Tsql
What columns generally make good indexes?
Sql Server
Database
Optimization
Database Design
Indexing
I need to store postal codes in a database. How big should the column be?
Database
Oracle
Globalization
Postal Code
How to select unique records by SQL
Sql
Database
Run a single Maven plugin execution?
Database
Maven
Testing
Maven 3
Maven Plugin
What's the difference between a catalog and a schema in a relational database?
Database
Schema
Catalog
Copying PostgreSQL database to another server
Database
Postgresql
Database development mistakes made by application developers
Database
Database Design
How to take MySQL database backup using MySQL Workbench?
Mysql
Database
Mysql Workbench
Database Backups
Postgresql - backup database and restore on different owner?
Database
Postgresql
Database Backups
Database Restore
Owner
Light weight alternative to Hibernate?
Java
Database
Hibernate
Sqlite
Convert SQLITE SQL dump file to POSTGRESQL
Database
Sqlite
Postgresql
Migration
MySQL Query to select data from last week?
Mysql
Sql
Database
Datetime
Remote connect to clearDB heroku database
Mysql
Database
Heroku
Database Connection
How to test an SQL Update statement before running it?
Mysql
Sql
Database
Testing
Myisam
SQLite UPSERT / UPDATE OR INSERT
Database
Sqlite
Upsert
Best way to store time (hh:mm) in a database
Sql Server
Database
Database Design
Datetime
How to import load a .sql or .csv file into SQLite?
Database
Sqlite
Import
Sqlite Shell
Why is a "GRANT USAGE" created the first time I grant a user privileges?
Mysql
Database
Privileges
Sql Grant
How do you rename a MongoDB database?
Mongodb
Database
How can I rename column in laravel using migration?
Php
Mysql
Database
Laravel
Migration
Microservices: how to handle foreign key relationships
Database
Microservices
What are the uses for Cross Join?
Sql
Database
Join
Relational Database
NOT DEFERRABLE versus DEFERRABLE INITIALLY IMMEDIATE
Sql
Database
1052: Column 'id' in field list is ambiguous
Mysql
Sql
Database
Join
Mysql Error-1052
SQLite - How do you join tables from different databases?
Sql
Database
Sqlite
Join
Difference between CLOB and BLOB from DB2 and Oracle Perspective?
Database
Oracle
Db2
Blob
Clob
Are Stored Procedures more efficient, in general, than inline statements on modern RDBMS's?
Sql
Database
Stored Procedures
What are projection and selection?
Sql
Database
Relational Algebra
Non-Relational Database Design
Database
Nosql
How to select bottom most rows?
Sql
Sql Server
Database
Select
Keyword
In MySQL queries, why use join instead of where?
Sql
Mysql
Database
How to export collection to CSV in MongoDB?
Mongodb
Csv
Schemaless
Database
Export database schema into SQL file
Sql
Sql Server
Database
Tsql
Export
How can I run just the statement my cursor is on in SQL Server Management Studio?
Sql Server
Database
Editor
How to use index in select statement?
Sql
Database
Indexing
Generating human-readable/usable, short but unique IDs
.Net
Database
Identity
Rename MySQL database
Mysql
Database
Linux
Rename
Is it possible to access an SQLite database from JavaScript?
Javascript
Html
Database
Sqlite
MySQL enum vs. set
Mysql
Database
Createuser: could not connect to database postgres: FATAL: role "tom" does not exist
Database
Postgresql
Why and when Liquibase?
Database
Liquibase
Server returns invalid timezone. Go to Advanced tab and set servertimezone property manually
Mysql
Sql
Database
Intellij Idea
Mysql Workbench
What does "select count(1) from table_name" on any database tables mean?
Sql
Database
Oracle
Difference between a theta join, equijoin and natural join
Database
Relational Database
Relational Algebra
When I should use one to one relationship?
Database
Database Design
Relational Database
How to get item count from DynamoDB?
Database
Amazon Dynamodb
Database vs File system storage
Database
File System-Storage
Can I have H2 autocreate a schema in an in-memory database?
Java
Sql
Database
H2
How to store Query Result in variable using mysql
Mysql
Database
Variables
Set
SQL how to compare two tables for same data content?
Sql
Database
SQLite INSERT - ON DUPLICATE KEY UPDATE (UPSERT)
Sql
Mysql
Database
Sqlite
Upsert
Describe table structure
Sql
Database
What is the optimal length for an email address in a database?
Database
Performance
Email
Database Design
Table Naming: Underscore vs Camelcase? namespaces? Singular vs Plural?
Database
Database Design
sqlalchemy filter multiple columns
Python
Sql
Database
Sqlalchemy
Show MySQL host via SQL Command
Mysql
Sql
Database
Pandas: how to change all the values of a column?
Python
Database
Pandas
PDO mysql: How to know if insert was successful
Php
Mysql
Database
Pdo
How to delete/create databases in Neo4j?
Database
Neo4j
Nodes
Sql Delete
Relationships
What does scale horizontally and scale vertically mean?
Database
Performance
Scalability
Best way to store password in database
Database
Security
Passwords
PG undefinedtable error relation users does not exist
Ruby on-Rails
Database
Ruby on-Rails-3
Oauth 2.0
Rake Task
Good Free Alternative To MS Access
Database
Ms Access
Desktop
What is a columnar database?
Sql
Database
A list of indices in MongoDB?
Mongodb
Indexing
Database Indexes
Mongodb Indexes
Database
Is it better to create an index before filling a table with data, or after the data is in place?
Sql
Database
Postgresql
Indexing
Saving timestamp in mysql table using php
Php
Mysql
Database
Sql Insert
Should I commit or rollback a read transaction?
Sql
Database
Transactions
How should you build your database from source control?
Database
Language Agnostic
Version Control
What are good alternatives to SQL (the language)?
Sql
Database
Deleting duplicate rows from sqlite database
Sql
Database
Sqlite
Relationship of Primary Key and Clustered Index
Sql
Sql Server
Database
Database Design
Java Embedded Databases Comparison
Java
Database
Comparison
Embedded Database
The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
Sql
Sql Server
Database
Sql Server-2012
Sql Query-Store
MySQL query finding values in a comma separated string
Sql
Mysql
Database
How to find SQLITE database file version
Database
Sqlite
Version
How to execute raw queries with Laravel 5.1?
Php
Mysql
Sql
Database
Laravel 5.1
Hidden Features of MySQL
Mysql
Database
Hidden Features
Why would you use Oracle database?
Database
Oracle
Comparison
Rake just one migration
Ruby on-Rails
Database
Migration
Rake
Maximum length for MySQL type text
Mysql
Database
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
Python
Mysql
Database
Django
Get all keys in Redis database with python
Python
Database
Redis
Good practices for designing monthly subscription system in database
Database
Database Design
Database Schema
Unique BooleanField value in Django?
Database
Django
Django Models
Django Admin
Django Forms
Sqlite or MySql? How to decide?
Mysql
Database
Sqlite
Is there a standard for storing normalized phone numbers in a database?
Database
How to determine total number of open/active connections in ms sql server 2005
Sql Server
Database
Sql Server-2005
Connection
Can I set up Cascade deleting in Rails?
Ruby on-Rails
Ruby
Database
What's the Hi/Lo algorithm?
Database
Algorithm
Primary Key
Identifier
Hilo
What is the point of "Initial Catalog" in a SQL Server connection string?
Sql Server
Database
Sql Server-2005
Connection String
Database Connection
Frontend tool to manage H2 database
Database
H2
Database Administration
Adding a column as a foreign key gives ERROR column referenced in foreign key constraint does not exist
Database
Postgresql
Foreign Keys
Alter Table
Is it possible to generate django models from the database?
Database
Django
Oracle
Orm
MySQL - how to front pad zip code with "0"?
Sql
Mysql
Database
Database Design
ORA-00904: invalid identifier
Sql
Database
Oracle
Ora 00904
how to use views in code first entity framework
.Net
Database
Entity Framework
View
Code First
What is cardinality in Databases?
Database
Database Design
Cardinality
MongoDB or CouchDB - fit for production?
Database
Mongodb
Couchdb
Kill a postgresql session/connection
Database
Postgresql
Export Data from mysql Workbench 6.0
Database
Export
Mysqldump
Mysql Workbench
How many rows in a database are TOO MANY?
Sql
Mysql
Database
Performance
Find stored procedure by name
Sql
Database
Sql Server-2005
Ssms
How do I remove keys?
Database
Redis
Redis Commands
Received an invalid column length from the bcp client for colid 6
C#
.Net
Sql Server
Database
Sql Server-2005
Oracle TNS names not showing when adding new connection to SQL Developer
Database
Oracle
Oracle Sqldeveloper
Tnsnames
Tns
Duplicate Entire MySQL Database
Mysql
Database
Linux
Default database named postgres on Postgresql server
Database
Postgresql
What is faceted search?
Database
Search
Full Text-Search
Faceted Search
Select NOT IN multiple columns
Sql
Database
Multiple Columns
Remove uniqueness of index in PostgreSQL
Sql
Database
Postgresql
Drop all tables command
Sql
Sqlite
Rdbms
Database
What are the advantages of using a schema-free database like MongoDB compared to a relational database?
Mongodb
Database
How to rethrow the same exception in SQL Server
Sql
Sql Server
Database
Tsql
Exception
Why is a database always represented with a cylinder?
Database
Database Design
Diagram
Diagramming
Database Diagramming
How does one check if a table exists in an Android SQLite database?
Android
Database
Sqlite
Where does MySQL store database files on Windows and what are the names of the files?
Mysql
Database
Windows
Room - Schema export directory is not provided to the annotation processor so we cannot export the schema
Java
Android
Database
Android Room
How should I resolve --secure-file-priv in MySQL?
Mysql
Database
How to reset / clear / delete neo4j database?
Database
Neo4j
Cypher
Getting random row through SQLAlchemy
Python
Sql
Database
Random
Sqlalchemy
Storing Business Hours in a Database
Database
Database Design
How to retrieve the last autoincremented ID from a SQLite table?
Database
Sqlite
Primary Key
Auto Increment
Junction Table
Android SQLite database: slow insertion
Android
Database
Performance
Sqlite
Insert
How can I stop redis-server?
Database
Ubuntu
Redis
How to store 7.3 billion rows of market data (optimized to be read)?
Database
phpmyadmin automatic logout time
Php
Mysql
Database
Cookies
Phpmyadmin
How to install SQL Server Management Studio 2012 (SSMS) Express?
Sql Server
Database
Installation
Ssms
Functions vs Stored Procedures
Sql
Sql Server
Database
Function
Stored Procedures
Import single database from --all-databases dump
Mysql
Database
Import
Mysqldump
Which is better H2 or HSQLDB?
Java
Database
Comparison
Hsqldb
H2
MySQL Error: : 'Access denied for user 'root'@'localhost'
Mysql
Sql
Database
Database Connection
How to create a new schema/new user in Oracle Database 11g?
Sql
Database Design
Oracle11g
Schema
Database
How do you interpret a query's explain plan?
Sql
Database
Performance
Oracle
Sql Execution-Plan
Comparison of database column types in MySQL, PostgreSQL, and SQLite? (Cross-Mapping)
Mysql
Database
Sqlite
Postgresql
Types
Where does Android store SQLite's database version?
Android
Database
Android Sqlite
How to add new Column to Android SQLite Database?
Android
Database
Sqlite
SQL Order By Count
Mysql
Database
Sql Order-By
How to select the nth row in a SQL database table?
Mysql
Sql
Database
Oracle
Postgresql
List of standard lengths for database fields
Database
Standards
MySQL: Check if the user exists and drop it
Mysql
Database
Does anyone know of a good library for mapping a person's name to his or her gender?
Database
Language Agnostic
How do I update a Mongo document after inserting it?
Python
Mongodb
Pymongo
Database
Do clustered indexes have to be unique?
Sql
Database
Tsql
Sql Server-2008
Clustered Index
Database design: Calculating the Account Balance
Sql Server
Database
Sql Server-2008
Database Design
Check if an object exists
Python
Database
Django
View
Model
How to recover a corrupt SQLite3 database?
Database
Sqlite
Corruption
Recovery
How to open and convert sqlite database to pandas dataframe
Python
Database
Sqlite
Pandas
Dataframe
What's the better database design: more tables or more columns?
Database
Database Design
Normalizing
Error renaming a column in MySQL
Mysql
Database
Alter Table
Mysql Error-1025
Doctrine 2: Update query with query builder
Php
Sql
Database
Doctrine
Export a MySQL Database to SQLite Database
Mysql
Database
Sqlite
Android backup/restore: how to backup an internal database?
Android
Database
Restore
Database Restore
Android Backup-Service
How do I use a dictionary to update fields in Django models?
Python
Database
Django
How to store JSON object in SQLite database
Android
Database
Json
Sqlite
Laravel: Error [PDOException]: Could not Find Driver in PostgreSQL
Php
Database
Postgresql
Laravel
Syntax Error
How to change the output folder for migrations with asp.net Core?
asp.net
Database
Entity Framework
asp.net Core
Command Line-Interface
What is the best way to seed a database in Rails?
Ruby on-Rails
Ruby
Database
Task
Seed
Using Rails, how can I set my primary key to not be an integer-typed column?
Ruby on-Rails
Database
Migration
Primary Key
Can I have multiple primary keys in a single table?
Database
Database Design
Primary Key
Composite Primary-Key
PostgreSQL how to see which queries have run
Database
Postgresql
Pgadmin
How does data denormalization work with the Microservice Pattern?
Database
Denormalization
Microservices
Storing a file in a database as opposed to the file system?
Sql Server
Database
Filesystems
Storage
How do two-phase commits prevent last-second failure?
Database
Distributed Transactions
Are Parameters really enough to prevent Sql injections?
asp.net
Sql
Database
Sql Injection
Why can you not have a foreign key in a polymorphic association?
Ruby on-Rails
Database
Foreign Key-Relationship
Polymorphic Associations
How to simulate a DB for testing (Java)?
Java
Database
Unit Testing
Testing
Jdbc
What is "Advanced" SQL?
Sql
Database
Synchronizing client-server databases
Sql
Database
Design Patterns
Client Server
Data Synchronization
Save child objects automatically using JPA Hibernate
Java
Database
Hibernate
Best way to code Achievements system
Php
Mysql
Database
Design Patterns
Minimum GRANTs needed by mysqldump for dumping a full schema? (TRIGGERs are missing!!)
Mysql
Database
Mysqldump
Database Backups
Sql Grant
How to test run an UPDATE statement in PostgreSQL?
Sql
Database
Postgresql
Modeling Product Variants
Mysql
Database
Database Design
Relational Database
Entity Attribute-Value
Just what is 'A big database'?
Database
Bulk-deleting in LINQ to Entities
C#
Database
Linq
Entity Framework
Linq to-Entities
database vs. flat files
Database
File
Django's ManyToMany Relationship with Additional Fields
Database
Django
Model
Many to-Many
IntelliJ IDEA 10 generate entity (POJO) from DB model
Database
Intellij Idea
Pojo
Is there a way to get a list of column names in sqlite?
Python
Database
Sqlite
How to update selected rows with values from a CSV file in Postgres?
Sql
Database
Postgresql
File Io
Csv
Creating new database from a backup of another Database on the same server?
Sql
Database
Sql Server-2008
MySql views performance
Mysql
Database
Performance
Optimization
Views
Mocking database in node.js?
node.js
Mongodb
Unit Testing
Mocking
Database
How do I output the results of a HiveQL query to CSV?
Database
Hadoop
Hive
Hiveql
Why are database features being ignored, and instead reinvented in the middle tier?
Database
Where can I find historical raw weather data?
Database
Datasource
Weather
Weather Api
CodeIgniter - return only one row?
Database
Codeigniter
How do I show the schema of a table in a MySQL database?
Mysql
Database
Schema
Database Schema
Installing and Running MongoDB on OSX
node.js
Mongodb
Macos
Shell
Database
pg_restore error: role XXX does not exist
Database
Postgresql
Restore
Can I do transactions and locks in CouchDB?
Database
Couchdb
Nosql
Indexing boolean fields
Sql
Mysql
Database
Indexing
How to delete mysql database through shell command
Mysql
Database
Linux
Shell
Ubuntu
Convert datetime value into string
Mysql
Database
String
Datetime
Getting-started: Setup Database for Node.js
Javascript
Database
node.js
What is it exactly a BLOB in a DBMS context
Sql
Oracle
Blob
Database
Blobstore
How to secure database passwords in PHP?
Php
Database
Security
Mysql database sync between two databases
Mysql
Database
Adding a leading zero to some values in column in MySQL
Mysql
Sql
Database
How to dispose TransactionScope in cancelable async/await?
C#
.Net
Database
Transactions
Async Await
OSError: [Errno 18] Invalid cross-device link
Python
Django
Database
Settings
Backend
How do databases work internally?
Database
Reference
Internals
What is the default Precision and Scale for a Number in Oracle?
Database
Oracle
Number Formatting
PDO::PARAM for type decimal?
Php
Mysql
Database
Pdo
Still Confused About Identifying vs. Non-Identifying Relationships
Database
Database Design
Relational Database
Identifying Relationship
Storing Images in DB - Yea or Nay?
Database
Image
Theory
Storage
Blob
Connecting postgresql with sqlalchemy
Python
Database
Postgresql
Orm
Sqlalchemy
What is the difference between HSET and HMSET method in redis database
Database
Redis
Laravel: How to get last N entries from DB
Php
Database
Laravel
Laravel 4
Eloquent
LocalDateTime remove the milliseconds
Java
Database
Date
Java 8
What's your opinion on using UUIDs as database row identifiers, particularly in web apps?
Database
Web Applications
Uuid
What's your #1 way to be careful with a live database?
Database
Hidden Features of PostgreSQL
Database
Postgresql
Rdbms
Postgresql 9.3
SQLite - ORDER BY RAND()
Sql
Mysql
Database
Sqlite
Random Access
Android database encryption
Android
Database
Sqlite
Encryption
Export a CREATE script for a database
Sql
Database
Postgresql
How to check if two data frames are equal
Database
R
Dataset
Compare
Dataframe
How can I merge many SQLite databases?
Database
Sqlite
Inventory database design
Database
Inventory
A list of Entity Framework providers for various databases
.Net
Database
Entity Framework
Orm
Simple check for SELECT query empty result
Sql
Sql Server
Database
When to use JCR (content repository) over other options?
Java
Database
Content Management
Jcr
Mongodb - Difference between running "mongo" and "mongod" databases
Mongodb
Shell
Database
PDOException SQLSTATE[HY000] [2002] No such file or directory
Php
Mysql
Laravel
Database
Pdo
How to remove a field completely from a MongoDB document?
Mongodb
Mongodb Query
Database
PostgreSQL: Create schema in specific database
Sql
Database
Schema
Postgresql
Storing image in database directly or as base64 data?
Mysql
Database
Image
Imagemagick
Base64
Strange PostgreSQL "value too long for type character varying(500)"
Sql
Database
Django
Postgresql
Postgresql 9.1
Insert 2 million rows into SQL Server quickly
C#
asp.net
Sql Server
Database
ado.net
Export table from database to csv file
Javascript
Sql Server
Database
Csv
Key value pairs in relational database
Sql
Database
Pros/cons of document-based databases vs. relational databases
Database
Nosql
Couchdb
Relational Database
Document Database
Best practices for using and persisting enums
C#
Java
Database
Enums
Persistence
Is it possible to get a history of queries made in postgres
Database
Performance
Postgresql
Timing
Example of a strong and weak entity types
Database
Weak Entity
How to generate the whole database script in MySQL Workbench?
Mysql
Sql
Database
Mysql Workbench
PGError: ERROR: permission denied for relation (when using Heroku)
Database
Postgresql
Heroku
Permissions
Cannot attach the file *.mdf as database
.Net
asp.net Mvc
Database
Entity Framework
asp.net Mvc-4
How can I get all sequences in an Oracle database?
Sql
Database
Oracle
Sequence
Toad
Firestore: How to get random documents in a collection
Swift
Database
Firebase
Data Modeling
Google Cloud-Firestore
Preferred Method of Storing Passwords In Database
Sql Server
Database
Security
Encryption
Passwords
Insert into ... values ( SELECT ... FROM ... )
Sql
Database
Syntax
Database Agnostic
Ansi Sql-92
Is storing a delimited list in a database column really that bad?
Database
Database Design
Database Normalization
How to show row numbers in PostgreSQL query?
Sql
Database
Postgresql
Of Countries and their Cities
Database
Countries
What type of NoSQL database is best suited to store hierarchical data?
Database
Tree
Nosql
Hierarchical Data
Select NULL Values in SQLAlchemy
Python
Sql
Database
Sqlalchemy
How to remove foreign key constraint in sql server?
Sql Server
Database
Foreign Keys
Find duplicate rows with PostgreSQL
Sql
Database
Ruby on-Rails-3
Duplicates
Postgresql 9.2
What do scale and precision mean when specifying a decimal field type in Doctrine 2?
Database
Symfony
Orm
Types
Doctrine Orm
mysqldump with create database line
Mysql
Database
Backup
Mysqldump
Best database field type for a URL
Sql
Mysql
Database
Run PostgreSQL queries from the command line
Database
Postgresql
What is the datatype for a password in PostgreSQL?
Database
Postgresql
Types
Using an Alias in SQL Calculations
Mysql
Sql
Database
Syntax
What happens when auto_increment on integer column reaches the max_value in databases?
Database
Auto Increment
Integer Overflow
Lastinsertid
MySQL InnoDB foreign key between different databases
Mysql
Database
Foreign Keys
Innodb
How to solve SQL Server Error 1222 i.e Unlock a SQL Server table
Sql Server
Database
Sql Server-2008-R2
Locking
Deadlock
AWS: can't connect to RDS database from my machine
Mysql
Django
Database
Amazon Web-Services
Amazon Rds
Is there a Profiler equivalent for MySql?
Mysql
Sql Server
Database
In sql server 2005, how do I change the "schema" of a table without losing any data?
Sql Server
Database
Detecting database tampering, is it possible?
Database
Tampering
Android Unit Tests Requiring Context
Database
Android
Unit Testing
What should I choose: MongoDB/Cassandra/Redis/CouchDB?
Mongodb
Cassandra
Redis
Couchdb
Database
Alias for column names in Rails
Ruby on-Rails
Database
Ruby on-Rails-3
Activerecord
Pros and cons of MongoDB?
Mongodb
Performance
Database
MySQL Trigger after update only if row has changed
Mysql
Sql
Database
Triggers
In Mongo, how do I pretty-print results so .find() looks like .findOne()
Mongodb
Database
How to populate options of h:selectOneMenu from database?
Database
Jsf
Selectonemenu
Django Model - Get distinct value list
Database
Django
Django Models
How to disable cascade delete for link tables in EF code-first?
C#
.Net
Database
Entity Framework
Ef Code-First
What is the difference between id and _id in mongoose?
Javascript
node.js
Mongodb
Mongoose
Database
How to replace a string in a SQL Server Table Column
Sql
Sql Server
Database
Database Administration
Can't connect to MySQL server on '127.0.0.1' (10061) (2003)
Mysql
Database
Localhost
Mysql Workbench
Windows 7-X64
How to delete duplicate rows without unique identifier
Sql
Database
Postgresql
Duplicates
Netezza
WooCommerce: Finding the products in database
Mysql
Database
Wordpress
Woocommerce
Product
What is caching?
Database
Caching
MySQL vs PostgreSQL? Which should I choose for my Django project?
Mysql
Django
Database
Postgresql
Django Migrations
How to write unit tests for database calls
Database
Unit Testing
Testing
Integration Testing
Data Access-Layer
What are MySQL database engines?
Mysql
Database
Storage
Innodb
Database Engine
Two phase commit
Database
Distributed Transactions
What's the difference between db:test:clone, db:test:clone_structure, db:test:load, and db:test:prepare?
Ruby on-Rails
Database
Unit Testing
What's the best strategy for unit-testing database-driven applications?
Database
Unit Testing
Orm
Mocking
Should each and every table have a primary key?
Database
Database Design
What database does Google use?
Database
Google Search
Google Cloud-Datastore
Bigtable
SQL query to select distinct row with minimum value
Sql
Database
Greatest N-per-Group
cannot create extension without superuser role
Database
Postgresql
Postgresql 9.1
When should I use Datomic?
Database
Database Design
Clojure
Datomic
When or why would you use a right outer join instead of left?
Sql
Database
Right Join
When shouldn't you use a relational database?
Sql
Database
Nosql
Relational Database
Best method to store Enum in Database
C#
Database
Visual Studio
Database Design
Enums
How many columns is too many columns?
Database
Database Design
Database Performance
Does MySQL ignore null values on unique constraints?
Mysql
Database
Unique Constraint
Can't import database through phpmyadmin file size too large
Mysql
Database
Apache
Phpmyadmin
Wampserver
How do I get the creation date of a MySQL table?
Mysql
Sql
Sql Server
Database
How do I get the total number of unique pairs of a set in the database?
Database
Math
Switching from SQLite to MySQL with Flask SQLAlchemy
Python
Mysql
Database
Sqlite
Flask Sqlalchemy
How to pg_dump an RDS Postgres database?
Database
Postgresql
Amazon Web-Services
Detected resolved migration not applied to database on flyway
Database
Flyway
SQLite as a production database for a low-traffic site?
Database
Sqlite
Production Environment
When and why are database joins expensive?
Database
Performance
Join
Relational Database
Denormalization
How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
C#
.Net
Database
Entity Framework
Linq to-Sql
Database/SQL: How to store longitude/latitude data?
Sql
Mysql
Database
Performance
Sqlperformance
Business Logic in Database versus Code?
Database
Architecture
Methodology
N Tier-Architecture
How is the data in a MongoDB database stored on disk?
Mongodb
Database
Looking for Thesaurus Data
Database
Thesaurus
MySQL stored procedures use them or not to use them
Mysql
Database
Performance
Database Design
Stored Procedures
How to implement a db listener in Java
Java
Database
Listener
What's a PostgreSQL "Cluster" and how do I create one?
Sql
Database
Postgresql
Postgresql 9.1
Usecases: InfluxDB vs. Prometheus
Database
Influxdb
Prometheus
Get the Last Inserted Id Using Laravel Eloquent
Php
Database
Laravel
Eloquent
What's the difference between CharField and TextField in Django?
Sql
Django
Database
Storage
Composite primary keys versus unique object ID field
Ruby on-Rails
Database
Design Patterns
Database Design
Best way to save a ordered List to the Database while keeping the ordering
C#
Database
Nhibernate
Sql Order-By
Which one to use, int or Integer
Java
Database
Performance
Types
Primitive
mysql server port number
Php
Mysql
Database
Database Connection
Port Number
In Django models.py, what's the difference between default, null, and blank?
Python
Database
Django
String
Integer
Case Sensitive collation in MySQL
Mysql
Database
Unable to instantiate default tuplizer [org.hibernate.tuple.entity.PojoEntityTuplizer]
Java
Database
Hibernate
How can I force entity framework to insert identity columns?
asp.net
Sql Server
Database
Entity Framework
Ef Code-First
PostgreSQL: Drop PostgreSQL database through command line
Database
Postgresql
Cassandra: text vs varchar
Database
Cassandra
Which SQL query is better, MATCH AGAINST or LIKE?
Sql
Mysql
Database
Search
Best practices to store CreditCard information into DataBase
Mysql
Database
Security
Database Design
Credit Card
Query if Android database exists!
Android
Database
How to dump mysql table structure without data with a SQL query?
Database
Mysql
how to use Blob datatype in Postgres
Database
Postgresql
PostgreSQL: SQL script to get a list of all tables that have a particular column as foreign key
Sql
Database
Postgresql
Foreign Keys
Django Model() vs Model.objects.create()
Python
Django
Database
Django Models
Doing a WHERE .. IN subquery in Doctrine 2
Sql
Database
Doctrine Orm
Best representation of an ordered list in a database?
Database
Database Design
Rdbms
Create mysql table directly from CSV file using the CSV Storage engine?
Mysql
Database
Csv
Storage Engines
Dataset - Vehicle make/model/year (free)
Database
Composite Primary Keys : Good or Bad?
Sql
Database
Database Design
Relational Database
Starting and populating a Postgres container in Docker
Database
Postgresql
Docker
Where can I find sample databases with common formatted data that I can use in multiple database engines?
Database
Sample
What are the performance improvement of Sequential Guid over standard Guid?
Database
Primary Key
Guid
Large public datasets?
Database
Performance
Dataset
Benchmarking
What are the options for storing hierarchical data in a relational database?
Sql
Database
Tree
Relational Database
Hierarchical Data
Compare two MySQL databases
Mysql
Database
Diff
In what way does denormalization improve database performance?
Database
Performance
Database Design
Normalization
Denormalization
Spring Security 3 database authentication with Hibernate
Database
Hibernate
Authentication
Spring Security
Naming of boolean column in database table
Sql Server
Database
Database Design
Naming Conventions
Why does VARCHAR need length specification?
Sql
Database
Varchar
Meaning of "n:m" and "1:n" in database design
Mysql
Database
Foreign Keys
Relationship
IllegalArgumentException: the bind value at index 1 is null
Android
Database
Sqlite
Android Contentprovider
Practical example for each type of database (real cases)
Database
Nosql
Relational Database
Rails :include vs. :joins
Ruby on-Rails
Ruby
Database
Join
Rails Activerecord
Swap unique indexed column values in database
Sql
Database
What is a Covered Index?
Sql
Database
Indexing
Stored procedures/DB schema in source control
Sql Server
Database
Version Control
What is the purpose of constraint naming
Sql
Database
Constraints
Naming
What is MYSQL Partitioning?
Mysql
Database
Partitioning
disable NOTICES in psql output
Database
Postgresql
Verbosity
Why use JPA instead of writing the SQL query using JDBC?
Java
Database
Jpa
Jdbc
Orm
I need a client side browser database. What are my options
Database
Web Applications
Plugins
Html
MongoDB normalization, foreign key and joining
Mongodb
Foreign Keys
Normalization
Database
Nosql
auto increment ID in H2 database
Database
Auto Increment
H2
Can I remove transients in the wp_options table of my WordPress install?
Mysql
Database
Wordpress
What's the difference between TRUNCATE and DELETE in SQL
Sql
Database
Truncate
Error Code: 2013. Lost connection to MySQL server during query
Mysql
Sql
Database
Mysql Workbench
What datatype to use when storing latitude and longitude data in SQL databases?
Sql
Database
Geocoding
Latitude Longitude
What is difference between SQLite and SQL
Android
Sql
Database
Sqlite
Using COALESCE to handle NULL values in PostgreSQL
Sql
Database
Postgresql
Null
Coalesce
Cloud Firestore deep get with subcollection
Database
Firebase
Google Cloud-Platform
Google Cloud-Firestore
Data Modeling
What is the best way to store media files on a database?
Mysql
Database
Audio
Multimedia
Could someone please explain LDAP?
Database
Ldap
Protocols
What databases do the World Wide Web's biggest sites run on?
Database
Database Design
Web Applications
Scalability
MySQL GROUP BY two columns
Sql
Mysql
Database
T-SQL Cast versus Convert
Sql
Sql Server
Database
Tsql
Auto Generate Database Diagram MySQL
Mysql
Database
Database Design
Diagram
Python: Number of rows affected by cursor.execute("SELECT ...)
Python
Sql
Rows
Database
How to get all table names from a database?
Java
Database
Jdbc
Database Metadata
Fill database tables with a large amount of test data
Mysql
Database
MySQL - Replace Character in Columns
Mysql
Sql
Database
What is the biggest ID number that autoincrement can produce in mysql
Mysql
Database
Integer
Auto Increment
Case statement in MySQL
Mysql
Sql
Database
Case
What are horizontal and vertical partitions in database and what is the difference?
Database
MongoDB opposite of $addToSet
Mongodb
Database
MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
Mysql
Sql
Database
Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user 'root'@'localhost'(using password:YES)
Mysql
Database
Connection
What are the performance characteristics of sqlite with very large database files?
Database
Performance
Sqlite
How do I index a database column
Sql
Database
Indexing
What are the advantages of using a single database for EACH client?
Database
Database Design
Multi Tenant
What is a good OO C++ wrapper for sqlite
C++
Database
Sqlite
How to store a list in a db column
Sql
Database
Oracle DB: How can I write query ignoring case?
Sql
Database
Oracle
Questions every good Database/SQL developer should be able to answer
Sql
Database
Cannot add a NOT NULL column with default value NULL in Sqlite3
Ruby on-Rails
Database
Sqlite
Sqlite3 Ruby
Populating django field with pre_save()?
Python
Database
Django
Model
Triggers
Bulk/batch update/upsert in PostgreSQL
Sql
Database
Postgresql
Insert
Sql Update
Conditional INSERT INTO statement in postgres
Database
Postgresql
Conditional Statements
Sql Insert
Postgres - Transpose Rows to Columns
Sql
Database
Postgresql
Crosstab
Transpose
Android: Cannot perform this operation because the connection pool has been closed
Java
Android
Database
Sqlite
Singleton
Persist Security Info Property=true and Persist Security Info Property=false
C#
Database
Ms Access
Database Connection
Connection String
Why doesn't Oracle tell you WHICH table or view does not exist?
Sql
Database
Oracle
Ora 00942
How do I test database-related code with NUnit?
C#
Database
Unit Testing
Tdd
Nunit
What is the easiest way to ignore a JPA field during persistence?
Java
Database
Hibernate
Jpa
Difference Between Schema / Database in MySQL
Mysql
Database
Schema
Database Schema
When to use CouchDB vs RDBMS
Database
Couchdb
Rdbms
How can I store and retrieve images from a MySQL database using PHP?
Php
Mysql
Database
Blob
Advantages / Disadvantages of pconnect option in CodeIgniter
Php
Database
Performance
Codeigniter
How do I do a "NOT IN" query in Mongo?
Mongodb
Database
How to duplicate a MySQL database on the same server
Mysql
Database
Sync
Replicate
Format date in MySQL SELECT as ISO 8601
Mysql
Database
Date Format
Iso8601
Generating a single Entity from existing database using symfony2 and doctrine
Php
Database
Symfony
Doctrine
MySQL - One To One Relationship?
Mysql
Sql
Database
Database Design
One to-One
Composite Primary key vs additional "ID" column?
Sql
Sql Server
Database
Database Design
SQLite insert speed slows as number of records increases due to an index
Database
Optimization
Sqlite
Insert
Liquibase lock - reasons?
Database
Oracle
Liquibase
Select MongoDB documents where a field either does not exist, is null, or is false?
Mongodb
Mongodb Query
Database
How to stop insertion of Duplicate documents in a mongodb collection
Mongodb
Mongodb Query
Database
Nosql
Mongodb: Failed to connect to 127.0.0.1:27017, reason: errno:10061
Windows
Mongodb
Database
Nosql
TypeError: tuple indices must be integers, not str
Python
Sql
Database
How do you write a case insensitive query for both MySQL and Postgres?
Mysql
Ruby on-Rails
Database
Postgresql
Heroku
MySQL foreign key to allow NULL?
Mysql
Database
Null
Foreign Keys
Referential Integrity
How to select data of a table from another database in SQL Server?
Sql
Sql Server
Database
Linked Server
Log to database instead of log files
Ruby on-Rails
Database
Logging
What are OLTP and OLAP. What is the difference between them?
Database
Database Design
Database Schema
Olap
Oltp
Postgresql find total disk space used by a database
Database
Postgresql
Diskspace
Laravel 4 db seed specific seeder file
Database
Laravel 4
How to get the trigger(s) associated with a view or a table in PostgreSQL
Sql
Database
Postgresql
Altering column size in SQL Server
Sql
Sql Server
Database
Tsql
Alter Table
docker-compose with multiple databases
Database
Docker
Docker Compose
Star-Schema Design
Database
Design Patterns
Data Warehouse
Star Schema
Dimensional Modeling
Is there a dbunit-like framework that doesn't suck for java/scala?
Java
Database
Testing
Scala
Dbunit
Can HTML5 databases and localStorage be shared across subdomains?
Database
Html
Dns
Subdomain
Local Storage
What does "slug" mean
Database
Couchdb
Should OLAP databases be denormalized for read performance?
Database
Database Design
Data Modeling
Olap
Data Warehouse
move table from one schema to another schema ?
Mysql
Database
What's the best separator/delimiter character(s) for a plaintext db file?
Database
Sqlite
Delimiter
Best place to close database connection
Android
Database
Sqlite
How to execute a .sql script from bash
Mysql
Database
Linux
Bash
Codeigniter - multiple database connections
Mysql
Database
Codeigniter
Is there a powerful database system for time series data?
Database
Performance
Time Series
oracle - what statements need to be committed?
Sql
Database
Oracle
Session
Commit
Update Query with INNER JOIN between tables in 2 different databases on 1 server
Sql Server
Database
Syntax
Inner Join
Fabric.js - how to save canvas on server with custom attributes
Database
Json
Savechanges
Fabricjs
Difference between Stream Replication and logical replication
Database
Postgresql
Database Replication
Using etcd as primary store/database?
Database
Kubernetes
Etcd
Altering database tables in Django
Database
Django
How to check if mysql database exists
Mysql
Database
Exists
MySQL not using indexes with WHERE IN clause?
Sql
Mysql
Ruby on-Rails
Database
Optimization
How to release possible Postgres row locks?
Sql
Database
Postgresql
Generate a resultset of incrementing dates in TSQL
Sql
Sql Server
Database
Sql Server-2005
Tsql
How can I find MAX with relational algebra?
Database
Relational Database
Relational Algebra
What's the difference between the name argument in @Entity and @Table when using JPA?
Java
Database
Jpa
Annotations
Persistence
How do I make a MySQL database run completely in memory?
Mysql
Database
How to do version control for SQL Server database?
Sql Server
Database
Svn
Version Control
Replace Into Query Syntax
Mysql
Sql
Database
Replace
Derived account balance vs stored account balance for a simple bank account?
Database
Database Design
Derived Table
Transactions for read-only DB access?
Database
Transactions
Data Access
When should I use stored procedures?
Sql
Database
Stored Procedures
How do I backup a database file to the SD card on Android?
Database
Android
Backup
Sd Card
Proper Repository Pattern Design in PHP?
Php
Database
Laravel
Repository
Repository Pattern
What does character set and collation mean exactly?
Mysql
Database
Database Design
Character Set
Which key/value store is the most promising/stable?
Python
Ruby
Database
Comparison
Unique key with NULLs
Mysql
Database
Null
Relational Model
Drawable to byte[]
Android
Database
Drawable
Android Bitmap
How to roll back migrations using Flyway?
Java
Database
Flyway
Rollback
Cursor adapter and sqlite example
Android
Database
Sqlite
Android Layout
Android Cursoradapter
MongoDB vs. Cassandra vs. MySQL for real-time advertising platform
Mongodb
Database Design
Cassandra
Database
Nosql
Why should I avoid loops when designing relationships for a database?
Database
Database Design
Loops
Data Modeling
Entity Relationship
PHPExcel and Text Wrapping
Php
Mysql
Database
Phpexcel
What is difference between primary index and secondary index exactly?
Mysql
Database
Oracle
Indexing
Rename a table in MySQL
Mysql
Database
Table Rename
How big can a MySQL database get before performance starts to degrade
Mysql
Database
Database Performance
Grant privileges on future tables in PostgreSQL?
Sql
Database
Postgresql
No UseDatabaseErrorPage() extension method in Net Core 3.0
C#
.Net
Database
Visual Studio
.Net Core
How do I alter a mysql table column defaults?
Mysql
Database
Timestamp
Alter
Securly Storing OpenID identifiers and OAuth tokens
Database
Security
Encryption
Openid
Oauth
What's the best database structure to keep multilingual data?
Mysql
Database
Localization
Translation
Multilingual
What are the differences between B trees and B+ trees?
Database
Data Structures
What are the differences between a superkey and a candidate key?
Database
converting database from mysql to mongoDb
Mysql
Mongodb
Database
IP address storing in MySQL database using PHP
Php
Mysql
Database
Ip
Field
Simple export and import of a SQLite database on Android
Java
Android
Database
Sqlite
Can I rollback a transaction I've already committed? (data loss)
Database
Postgresql
Data Recovery
What is the syntax meaning of RAISERROR()
Sql
Sql Server
Database
Sql Server-2008
Sql Server-2008-R2
List all values of a certain field in mongodb
Mongodb
Mongodb Query
Database
Laravel nested relationships
Php
Mysql
Database
Laravel
Import psycopg2 Library not loaded: libssl.1.0.0.dylib
Python
Database
Postgresql
Python 2.7
Postgresql 9.3
How to connect to a local database in SQL Server Management Studio?
Sql Server
Database
Ssms
Can't export my database from mysql workbench
Mysql
Database
Export
Mysql Workbench
Anyone using CouchDB?
Database
Couchdb
How to get a value from the last inserted row?
Java
Database
Postgresql
Jdbc
What is a View in Oracle?
Database
Oracle
Views
Django persistent database connection
Python
Database
Django
Mod Wsgi
Persistent
Threaded Django task doesn't automatically handle transactions or db connections?
Python
Database
Django
Multithreading
Transactions
Database schema design for a double entry accounting system?
Database
Database Design
Accounting
View all foreign key constraints for entire MySQL database
Mysql
Foreign Keys
Database
What's the difference between " = null" and " IS NULL"?
Mysql
Database
Is DbContext the same as DataContext?
C#
Database
Entity Framework-4
What MySQL drivers are available for node.js?
Javascript
Mysql
Database
node.js
What is the best practice in naming your "user" table?
Database
Database Design
Naming Conventions
"Cannot drop database because it is currently in use". How to fix?
Database
Unit Testing
Entity Framework
Entity Framework-4.1
Database Connection
sqlite3.OperationalError: unable to open database file
Python
Database
Django
Sqlite
Django Settings
Database design: 3 types of users, separate or one table?
Mysql
Database
Database Design
User Interface
Relational Database
Database design for user settings
Mysql
Sql Server
Database
Database Design
Relational Database
How to automatically destroy django test database
Python
Database
Django
Testing
Hudson
phpMyAdmin Duplicate Table
Php
Database
Phpmyadmin
How to increase MySQL connections(max_connections)?
Mysql
Database
Sockets
Database Connection
How to use multiple databases in Laravel
Php
Mysql
Laravel
Database
Job for mysqld.service failed See "systemctl status mysqld.service"
Mysql
Linux
Database
Amazon Web-Services
PreparedStatements and performance
Java
Database
Performance
Prepared Statement
in general, should every table in a database have an identity field to use as a PK?
Sql
Database
Database Design
What does =* mean?
Sql
Sql Server
Database
Tsql
sqlite select with condition on date
Sql
Database
Sqlite
Date
Calculate Time Difference Between Two Rows
Sql Server
Database
Difference Between-Rows
Why use SQL database?
Sql
Database
Database Design
Data Structures
What effects does using a binary collation have?
Mysql
Database
Binary
String Comparison
Collation
PG::ConnectionBad - could not connect to server: Connection refused
Ruby on-Rails
Ruby
Database
Postgresql
Database Connection
How do I test Rails migrations?
Ruby on-Rails
Database
Testing
Share SQLite database between 2 android apps?
Android
Database
Sqlite
Sharing
Conditional logic in PostDeployment.sql script using SQLCMD
Sql
Database
Sql Server-2008
Sqlcmd
Why no many-to-many relationships?
Sql
Database
How can I iterate over ManyToManyField?
Python
Database
Django
Orm
Model
Where to find practical well-designed database schema examples to learn from?
Database
Optimistic locking in MySQL
Mysql
Sql
Locking
Database
Optimistic
What do these Copy Only Backup options mean?
Sql Server
Database
Sql Server-2008
Find duplicate column value in sqlite
Database
Sqlite
How to execute multiple queries using psql command from bash shell?
Database
Postgresql
Shell