• Adding a new table to our SQLite database

    My team and I have already created SQLite tables but we're looking to add a new table to our database. Here's the DB version: private static final int DATABASE_VERSION = 2; We've also added this string to create the table: private static final String DATABASE_CREATE_color = "CREATE TABLE IF NOT...

    ITKE346,285 pointsBadges:
  • What’s the maximum MIMEtype length for storing type in a database?

    Would anyone be able to tell me what people are using for the length of a MIMEType field in their databases? The longest one that we use is 72 bytes but we're looking to see if there are longer ones. We've actually started using 250 now but is there anything longer? Thanks for the help.

    ITKE346,285 pointsBadges:
  • How to remote connect to a ClearDB Heroku database

    How would I be able to perform a remote connection my ClearDB MySQL database (on Heroku) using the MySQL Query Browser? Basically, I'm trying to get a URL, port, login and password. Thanks so much.

    ITKE346,285 pointsBadges:
  • How can I secure my database password using PHP?

    I'm using a PHP application for my database so obviously I need to pass a login / password to make a database connection. And I'm using a minimum-permission login for the application so PHP needs to know those credentials somewhere. Is that the best way to secure my password? I'm just worried that...

    ITKE346,285 pointsBadges:
  • Moving a Redis database from one server to another

    We have a Redis server that's running on a cloud instance but now we're trying to migrate it to a new cloud instance (and actually use it as our new Redis server). I know in MySQL that I would just need to export the database and import it to the new server. But how can we do this through Redis?...

    ITKE346,285 pointsBadges:
  • What’s the difference between horizontally and vertically scaling a database?

    I'm working with two different databases (NoSQL and MySQL) and we're looking to measure the scalability of each database. What's the difference between vertically and horizontally scaling each one? I would appreciate any help.

    ITKE346,285 pointsBadges:
  • How can I get the database username and password in Ruby on Rails?

    I'm currently using Ruby on Rails but I'm looking to do some outside database work. Is there an actual way to get my database info (username, password, host, etc.) for the current environment? I'm trying to get it so I can connect like this: con = Mysql.real_connect("host", "user", "pw",...

    ITKE346,285 pointsBadges:
  • How to authenticate database users with Hibernate

    For our database, I need to authenticate several users but we can't figure out how to do it with Hibernate. Is is actually possible to do it? If so, how?

    ITKE346,285 pointsBadges:
  • How to we keep track of our stored procedures using a source control system?

    We currently use SQL Server at our company and we're looking to find out if we should keep track of our stored procedures / database schema in our source control system. For example, when we make a change to one of our tables, how do the changes get into the source control? Thank you for your help!

    ITKE346,285 pointsBadges:
  • Connect to DB2 of V5R1 from .NET application

    Hi all, I want to connect to AS/400 DB2 from my .NET application. I just want to know which are prerequisites for this connectivity and data retrieval.

    hunshabbir71,510 pointsBadges:
  • Access Subform Repeating Data

    I have brought in a subform into my main form and link the child and master fields, but under each page the subform repeats the information down the page, but in the report on its own (i.e. before it is a subform) it doesn't repeat - what do I need to do to sort this?

    SJJ5 pointsBadges:
  • What new features would you like to see on ITKnowledgeExchange.com?

    Members We are always looking for ways to make finding answers and communicating with peers easier on this site. With that said I would love to hear from you on what features you think would make this site better. Some ideas could be to promote users Knowledge points more, allow more senior users...

    ITKE346,285 pointsBadges:
  • PowerBuilder Printing Problem

    hi all, i have a problem, when i print a powerbuilder report using a network printer, from some PCs the report is blank where from some others it is printed properly. i don't think so that the problem is in PowerBuilder because all PCs uses the same EXE. thanks in Advance.

    Ghassanhaith0 pointsBadges:
  • How can I force my code to remove the database?

    I keep getting this "Cannot drop database "test_db" because it's currently in use" when I'm using this code: [TestFixture] public class ClientRepositoryTest { private const string CONNECTION_STRING = "Data Source=.;Initial Catalog=test_db;Trusted_Connection=True"; private DataContext _dataCntx;...

    ITKE346,285 pointsBadges:
  • Can I set a default storage engine on MySQL database?

    I'm currently working on writing a SQL query to create a MySQL database with several default options including: character set and collation. I'm trying to figure out if I can actually set the default storage engine for tables in the database to InnoDB. Does anyone know if that's possible? Thanks so...

    ITKE346,285 pointsBadges:
  • What’s the better option for SQL Where clause: IN vs. OR?

    I'm working with my team on several huge databases and we need to know which would be a better option for us in the SQL Where clause: IN vs OR? Is there actually a difference between the two? Thanks so much.

    ITKE346,285 pointsBadges:
  • Where are my database files stored on my Android device?

    I've just created a SQLite database on my Android device. The program reads/writes to the database so the file has been created. Here's what the SQLiteDatabase.mPath is set to: db.mPath = "/data/data/dev.client.android/databases/clientDB.db" But my problem is when I'm browsing the directories on my...

    ITKE346,285 pointsBadges:
  • Should I store data in MYSQL as JSON?

    Should I actually store data in MySQL as JSON? A friend of mine did this and and it actually made their database's performance better and decreased latency. He's also told me that storing data as JSON makes everything easier. But is it easy to delete /edit data stored as JSON? Thanks.

    ITKE346,285 pointsBadges:
  • How can I get the size of MySQL database?

    Say my MySQL database is called v3...how would I be able to get the size of it? Thank you!

    ITKE346,285 pointsBadges:
  • Can I write a case insensitive query for MySQL and PostgreSQL?

    I've been running a MySQL database locally for our development team but it's been deploying to Heroku which currently uses PostgreSQL. Heroku has been handling most everything I need but we use PostgreSQL for case-insensitive statements. What would be the best way for me to write a case-insensitive...

    ITKE346,285 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following