I have a database of several tables in which the first field is defined as: 'ID' INTEGER NOT NULL UNIQUE ... PRIMARY_KEY('ID') I do not use the AUTOINCREMENT keyword for any of these tables yet my...

I recently started researching database features of databases. At the moment I'm looking into Neo4j Graph database. Unfortunately, I can't find every bit of information I need. I found most infor...

I have 3 MySQL tables for a membership system. users: Minimum requirement to be a user, only related to account info (email, password, is_activated, etc) user_profiles: Personal information provi...

After writing the code, When I run my pgloader script, it fails this way: load database from mysql://xxx:yyy127.0.0.1/zzz into pgsql://xxx:yyy@localhost/zzz including only table names matching...

As a long time Toad for Oracle user, I have gotten used to hitting Ctrl+Enter and having just the statement under the cursor be executed. In SQL Server Management Studio, hitting F5 runs the entir...

I'm currently using the RabbitMQ (3.6.2-1) on Ubuntu(16.04) in production. Producers publish messages and consumers consume messages and everything works correctly but sometimes RabbitMQ doesn't re...

I'm developing app in Flask and it requires DB, so what I have is I do: app = Flask(__name__) @app.before_request def init_db_connection: # here I connect to my DB @app.teardown_request def dest...

I'm doing some data munging which would be quite a bit simpler if I could stick a bunch of dictionaries in an in-memory database, then run simply queries against it. For example, something ...

I've got a Flyway exception: FlywayException: Detected failed migration to version 1.0 I looked for on documentation and forums but I didn't found what mean this exception. Please someone can te...

I am using alembic to manage my database changes. Other people may also add changes to this database. Everything is set up correctly and this is currebtly working fine. However, because we are many...

intellij idea data sources doesn't see existing table in my mysql database, while Netbeans see it. i've created a table in the database. When i create connection in intellij idea data sources, it s...

I've been trying to create a new database connection on workbench. However, every time I test a connection there is an error message that says Failed to connect to mysql at 127.0.0.1:3306 with u...

I have a Mix project and I am trying to insert some data into my local database. I have added the Mongo dependency to my project, then added the lines of code for connecting to the database and for...

I'm using Rails migrations to manage a database schema, and I'm creating a simple table where I'd like to use a non-integer value as the primary key (in particular, a string). To abstract away from...

I created a table using psycopg2 in jupyter notebook. This was done successfully and I didn't get any error. Now I want to see the table in the pgAdmin interface, but it doesn't appear there. Why? ...

Is it possible to put comments into Hibernate Query Language? If so, how?

I'm intrigued in the database service Datomic, but I'm not sure if it fits the needs of the projects I work on. When is Datomic a good choice, and when should it be avoided?

The idea is that I have local database named northwind, and with postgres_fdw I want to connect with another database named test on localhost (remote connection simulation, for situations like when...

I want to retrieve the values from a database table and show them in a html table in a page. I already searched for this but I couldn't find the answer, although this surely is something easy (this...

Every socket of MySQL Database will have defaults connections as 100 but I am looking for any way to increase the number of possible connections > 100 to a socket connection of MySQL Database.

I am not sure if its possible, but would really appreciate any assistance. I am looking for a script which can generate the complete list of SQL Server databases with the following details for eac...

My MongoDB is hosted on compose.io and is called ScroungeBA. I try to create a user with some built-in roles which by the documentary only work in the admin database: MongoDB provides all other...

I'm generating a scientific application that performs a lot of number crunching in Java and C, and accuracy is critical. There is no number crunching done inside the Oracle database (it's merely us...

I have this message in my DBeaver Can you help me to fix the problem? Network error Motif: Network unavailable: javax.net.ssl.SSLHandshakeException:PKIX path building failed: sun.security.provid...

I am having SQL server 2008 and i am having 10 different databases in it and now i want to search one stored procedure that in which database the stored procedure is present. Mentioned as duplicat...