Examples of programming questions in database

PostgreSQL - GROUP BY timestamp values?
How to backup some tables with data and some tables only schema PostgreSQL
How to store site wide settings in a database?
Difference between Transactional and Reporting Database
In Redis, how do I get the expiration date of a key?
How do I list all stored procedures in Informix?
how to copy data from file to PostgreSQL using JDBC?
How do you store a collection of Strings in SQLite on Android?
How to copy database in use to other database in django?
Share SQLite database between 2 android apps?
DAO and JDBC relation?
Conditional logic in PostDeployment.sql script using SQLCMD
CodeIgniter database connections not being closed
How To Test If Cursor Is Empty in a SQLiteDatabase Query
How can I transfer a mongodb database to another machine that cannot see the first one
Is there a limit to how long a SQL query can be in SQL Server?
select all records created within the hour
How to configure DB Navigator for Jetbrains PHPStorm and WebStorm
General Mysql database maintenance advice
SQL query to find rows with at least one of the specified values
Database efficiency - table per user vs. table of users
Changing schemas in mongoDB/mongoose
Which normal form does this table violate?
Storing image files in Mongo database, is it a good idea?
Is Python DBM really fast?
In-memory table in PostgreSQL
CURDATE() causes an syntax error
Generating and reading barcode
Audit tables: Each field for table or one table
How to represent end-of-time in a database?
storing data locally on the iphone
How to handle MySQL deadlock situations on an application level?
How to store year month in database?
MySQL GROUP by Regex?
How does table alias names affect performance?
Put ResultSet into HashMap?
Upload image directly through mySQL Command Line
Detached Entity and Managed Entity
Django form/database error: value too long for type character varying(4)
Trigger to update current date in Postgres 9
Relationships between tables from different databases
My redis server "crashed" and I lost all my data because it's all in memory?
Sorted String Table (SSTable) or B+ Tree for a Database Index?
Minimum GRANTs needed by mysqldump for dumping a full schema? (TRIGGERs are missing!!)
How to Count the rows in Hibernate Query Language?
Should I really use foreign keys?
Is there any 'web-based' sql test environment?
How to get a first and last date in a mysql database table
How to delete all views from MySQL database using MySQL query/command?
MYSQL TINYBLOB vs LONGBLOB
How can I automatically unlock tables in Oracle after a given time?
Creating tab delimited file
How to use SharedPreferences to save more than one values?
Can SQL Server Express LocalDB be connected to remotely?
Select subset of rows using Row_Number()
Building a web application with multiple database instances or just a single instance
Empty table data and reset IDENTITY columns
SQLite database scheme as Entity Relationship Model
c# working with Entity Framework in a multi threaded server
Which database engine to choose for Django app?
Create an Access database file (.mdb or .accdb) using Java
Mongodb - Change db name
Connect android app with the database from a Website
Cannot truncate table because it is being referenced by a FOREIGN KEY constraint
How to create temporary procedures in MySQL?
Does a SELECT query always return rows in the same order? Table with clustered index
Default isolation level in Spring Framework
Syntax error when running a MySQL CREATE TABLE statement
MySQL not using index for ORDER BY
Which embedded DB written in Java for a simple key/value store?
Oracle parents key not found
expects parameter '@ID', which was not supplied?
How to best store a timestamp or date in a database?
SQL Server INNER JOIN multiple inner joins with multiple relations
How do you clone ( duplicate ) a MongoDB object in a collection of the same db?
How to pass data to IN query in rails 3
Android how to query huge database in android (cursor size is limited to 1MB)
How to handle authentication/authorization with users in a database?
Dropping unique constraint for column in H2
Storing a SQL string array, and subsequent querying
double inner join in access db
Count Multi-level marketing (tree) record in php mysql
How to delete multiple rows?
How to set a MySQL row to READ-ONLY?
Database schema that manages weekly timesheets
What is the difference between a file-based database and a server-based database?
How do I issue HGET/GET command for Redis Database via Node.js?
Database modeling for international and multilingual purposes
sqlite database not created
Purpose of nested transactions
oracle - integrity constraint violated - child record found
using strpos in mysql?
Size of memory allocated to a SQLite in-memory database
How to connect to a database that requires password without exposing the password?
Order SQL by strongest LIKE?
How to create instance of org.springframework.dao.DataAccessException?
how to write Oracle Function For Convert Date to persian (jalali)
How to install SQL Server Management Studio 2012 (SSMS) Express?
MySQL - Can we order by column position instead of name?
Storing Business Logic in Database
sqlite throwing a "String not recognized as a valid datetime
PDO SQL-state "00000" but still error?
Check for x consecutive days - given timestamps in database
WFMLRSVCApp.ear file not found
Database Pivoting - what is the purpose?
How to check if a table or a column exists in a database?
How can I attach a database to an app in Heroku?
error in sqlite "DROP TABLE IF EXISTS" android
How to disable innodb in mysql?
MySQL Query database size
Django: lock particular rows in table
SQL Error: table specified more than once
Date range overlapping check constraint
Show all keys in redis - in one line
Why are relational databases having scalability issues?
make custom queries using sequelizejs
intellij idea data sources doesn't see existing table in the database
How to structure the tables of a very simple blog in MySQL?
How to copy sql server database from one to another server without any backups
How to perform one-time DB sync to another DB in MongoDB?
JPQL ManyToMany select
Max length of "tzname" field / timezone identifier name
SQL Server string constraints
How many foreign keys is too many?
Trying To Create New Wordpress Database Table
How to select rows by date in sqlite
Clean couchdb and restart
How to create unique index on fields with possible null values (Oracle 11g)?
Figure out if a table has a DELETE on CASCADE
Write to several database in Redis for python
Is there a command to check to see if a database exists from Entity Framework?
Assigning to 'double*' from incompatible type 'double'
Inserting a Zero instead of NULL while performing LEFT OUTER JOIN in MYSQL
How can I get all sequences bound with a table in PostgreSQL
What is the best design for a database table that can be owned by two different resources, and therefore needs two different foreign keys?
Table rownum returns 0 records if rownum is tested for value greater than 100
What is the difference between hashing and indexing?
How to index polymorphic table in rails with not unique "association_type" and "association_id
how to do fuzzy search in big data
How to view database diagram in a Code First using localdb
How I can Insert Data in the MySQL Database?
MySQL: Convert Unencrypted Password Column to MD5 Hash
PHP : Using a variable to hold a table name, and using that variable in queries
how to find partition of record oracle
Override file while backup database
LINQ Lambda, Group by with list
When to use a query or code
Get row index in datatable from a certain column
Does closing Connection automatically close statement and resultset?
Cannot persist computed column - not deterministic
DBUnit - integrity constraint violation: foreign key no action; SYS_FK_10556
Why do SQL databases use a write-ahead log over a command log?
Passing MySQL functions to Eloquent ORM query
SQLite define output field separator on a single line command
(1242, 'Subquery returns more than 1 row') error in Django?
Elastic search, multiple indexes vs one index and types for different data sets?
How to export part of a table as SQL in Adminer?
Get array/list of entities from Doctrine
The data types text and varchar are incompatible in the equal to operator
What is a database index?
Normalize table to 3rd normal form
CodeIgniter: Multiple Databases - Accessing database config in a second database
Get the max length allowed in column, mysql
Multiple access to a single SQLite database file via System.Data.SQLite and c#
Save little information as setting in android (like first time that app is run)
It's possible to delete a row in heroku postgresql?
MYSQL - Select only if row in LEFT JOIN is not present
Return the count of rows grouped by week MySQL
radius search by latitude / longitude
Database One-to-Many with two foreign key fields in Laravel
Class [org.apache.derby.jdbc.ClientDriver] not found. When trying to connect to db
Blocking factor in a DBMS
Import csv into sqlite with autoincrementing primary key
is it good to store decimal value as varchar in mysql?
Refresh the database connection if connection drops or times out
Make DbDataReader start reading again from the beginning of the result set
Sharing data between SQL databases
How to retrieve same column twice with different conditions in same table?
To get MYSQL query execution time in Query
Using IF / ELSE to determine a SELECT INTO statement
Import .csv file to Sqlite in Android
How to solve org.hibernate.StaleObjectStateException when copying data from one database to another?
How to add date in sqlite database
Cyrillic symbols in SQL code are not correctly after insert
Deciding on foreign key while implementing one to one relationship in MySQL
Why does referencing a SQLite rowid cause foreign key mismatch?
what is different between database clustering and database partitioning
Is it practical to have back-end (database side) validation for everything?
Securely providing the database password in a Rails app
Passing multiple columns in myBatis <assoctiation>
Database Structure for Web Messaging System
Why SUM(null) is not 0 in Oracle?
Get the nearest longitude and latitude from MSSQL database table?
How to store graph data in a database?
Mysql_install_db cannot find file
mysql view super slow
What is wrong with my relationships in SQL Alchemy?
Fulltext search vs standard database search
SQL Query Stuck in Statistics State
Python Redis connection should be closed on every request? (flask)
BLOB data returned in MySQL using AES_DECRYPT with ORDER clause
Practical example for each type of database (real cases)
Why hibernate always call "update" statement after using "select" statement in MySQL?
Have model contain field without adding it to the database?
How to create UNIQUE constraint in SSMS 2012
Difference between non-repeatable read vs dirty read
Replace spaces with dash and copy into new column
How to rename database in Heroku?
multiple databases and multiple models in django
connect to database c#
JUNIT : run setup only once for a large number of test classes
MySQL Database Connection With Visual Studio 2013 Preview
Refactoring Liquibase changelog files
Store Images in MySQL Database
Entity Framework: How to detect external changes to database
creating a database in mysql from java
JTable header not showing
How to dynamically create row and column of table in jsp page
Java - How to get Column name on Result Set
Why does Add-Migration sometimes create duplicate migrations?
Storing and querying JSON from a database
How to combine a column name into MySQL "LIKE" clause
Difference between .SQL and .DUMP files
Storing/Tracking user activity on a website
Plot tables and relationships from Postgresql tables
postgresql autovacuum not working although process is running
Insert records to Heroku database
Way to store various shop opening times in a database
Sql question marks in insert statement
Embedded document database for Node.js
property.GetValue(this, null) leads to "Object does not match target type
limit vs exists vs count(*) vs count(id) in MySQL
Disadvantages of many indexes in MySQL
Concurrent db table indexing through alembic script
ExecuteScalar call throwing exception "Object reference not set to an instance of an object
What is the recommended equivalent of cascaded delete in MongoDB for N:M relationships?
MySQL import - How to ignore Drop table if exists line?
Disadvantages of creating multiple indexes in a PostgreSQL table
Codeigniter WHERE AND OR together
What is the max JDBC batch size?
Is there a performance hit using decimal data types (MySQL / Postgres)
Schema for music lists + playlists web app
Range query for MongoDB pagination
Many tables or rows, which one is more efficient in SQL?
Spring batch Job read from multiple sources
PostgreSQL nested INSERTs / WITHs for foreign key insertions
Insert ignore" vs "select and insert
Automatic TRUNCATE table in MySQL
Symfony2: How to remove an element from a Doctrine ArrayCollection (many-to-many relation)?
Django filter datetime base on date only