Questions tagged [database-management]

115 questions
3
votes
5 answers

What is "SQLiteDatabase created and never closed" error?

I have closed the database in my adapter class, so whay is this error showingup on logcat but my application is not forcr closing but only error is showing on log cat..where i shuold have to close the database for ignoring this error...? my errors…
shyam
  • 1,276
  • 4
  • 25
  • 51
3
votes
2 answers

Can I use firebase for only auth and any other SQL database to store other user data?

Basically I am building a social media type app. I want to manage the auth using firebase firestore (as It is easier) and the contents posted by the user in any other SQL database. Like, if the user uploads a image it will be stored in my own…
3
votes
3 answers

zend database migration scripts

I would like to know how do you guys work in Zend Framework environment especially how to keep the database table up to date with others team (database change management) . I have small team who works at their home and we need to have latest…
nightingale2k1
  • 10,095
  • 15
  • 70
  • 96
3
votes
2 answers

MySQL Community Server - What is it exactly?

Hello fellow StackOverFlow-ians. I am currently learning about PHP and I have found out that it is deeply related to "MySQL". I looked it up, and what I think is that "SQL" is a language used to help "Database Management Systems" run "Relational…
3
votes
1 answer

SQL Server "Space Available" Alert?

I am looking for a way to send alerts when a database or log reach 10% space remaining. Let me preface this question by saying that I intentionally did not include the word "file" in the question. While I have researched this question it appears…
tlum
  • 913
  • 3
  • 13
  • 30
2
votes
2 answers

What permissions does the health_check_user for pgpool-II need?

I'm confused about a point of pg_pool-II's documentation. The health_check_user is used to determine the health of DB cluster servers, but what abilities does the health_check_user need? As there are no configuration options to get a password for…
troutwine
  • 3,721
  • 3
  • 28
  • 62
2
votes
0 answers

Is there a client app like MongoDB Compass for Firebase Firestore?

I've started using Firebase Firestore on a project. The Firestore management tool seems very basic and doesn't have things like a query editor, ability to duplicate records etc... Is there a client application like MongoDB Compass or Sequel Pro for…
Jack Vial
  • 2,354
  • 1
  • 28
  • 30
2
votes
2 answers

How I can store and manage a db schema in Arango or Neo4j in Node.js project

I can't understand how to manage a schema to have the same database structure for different environments(development, testing and production). And in deployment server. How to define, store and update ArangoDB or Neo4j schema. I know sequelize…
2
votes
0 answers

SQL Server 2008 R2 Maintenance Plan - anything else?

I have a number of SQL Server 2008 R2 databases that haven't had any maintenance plans run on them since birth, as my ISP's server provides a SQL Server version that doesn't have the Maintenance Plan option. I've trawled through the numerous…
2
votes
2 answers

What advanced security options exist for Neo4j?

Our company is considering Neo4j for a database solution. We're using to Oracle dbs, and have relied upon their built in user authentication management to control who can connect to the db, who has read or write access, and what they are allowed to…
InverseFalcon
  • 29,576
  • 4
  • 38
  • 51
2
votes
2 answers

How can I create a data base management system?

I have to create a data base management system as a project for the school but I don't know how to. It doesn't have to be very sophisticated. Is there any tutorial that shows how to do it? And, what would be the most appropriate language to do that?
Adrian
  • 829
  • 5
  • 14
  • 21
2
votes
4 answers

Oracle automatic GRANT permissions

I'm trying to analyze the security that DBMS provides, the following scenario provides a brief description of what I'm looking for. // The current user connected to the database is "master" // 1. Basic step to create the new user CREATE USER…
user1899713
  • 85
  • 2
  • 7
  • 14
2
votes
3 answers

how to determine slow queries?

My site is experiencing a really slow loading time. I have suspected that it might be javascript or php that causes longer loading time but i have tested my site in YSlow and its grade is B which i think is not bad. Now i want to check my database…
Jayson O.
  • 485
  • 1
  • 6
  • 20
2
votes
2 answers

How should I managed a database for register/log in with Facebook & Twitter

I am creating an iOS App which the user will be able to login to via his account with our website (internal), or via Facebook or Twitter. What I would like to know is how should I manage the database in order to verify his Facebook / Twitter account…
max_
  • 24,076
  • 39
  • 122
  • 211
1
vote
1 answer

Database management Ruby On Rails

I'm new to Ruby On Rails, I allways used php to develop websites. With php I used MAMP and Sequel Pro to manage my database. I would like to use Sequel Pro to manage my Rails database but I can't find the parameters to setup my Sequel Pro. Any help…
Thijs
  • 3,015
  • 4
  • 29
  • 54