• How to store an IP address in MySQL

    Could anybody tell me what the right field type would be for storing an IP address in MySQL? Also, what's the right way to store it too?

    ITKE346,430 pointsBadges:
  • What’s the better embedded database: SQLite or MongoDB?

    I've been working on a RSS reader application and I'm looking at several different back end databases to use. I need the database to be embedded because I don't want the users to install a database server. I'm between SQLite and MongoDB. Which one is the better choice?

    ITKE346,430 pointsBadges:
  • How many rows are too much in a MySQL database?

    We have a MySQL InnoDB that has over a million records. Is that too much to hold? Can my database handle that many records? We're curious because some of our queries are slower with a table that has 1,000,000 rows than one with 100 rows.

    ITKE346,430 pointsBadges:
  • Best way to talk to a database using Sinatra

    We're using Sinatra software and we've noticed that it doesn't provide an ORM (unlike Ruby on Rails). So we're trying to figure out how to actually talk to the database in a Sinatra app. Or is it only for apps that don't use a database? Thank you.

    ITKE346,430 pointsBadges:
  • How to copy data from one SQLite database to another

    My team has two different SQLite databases that have similar data but with different purposes and we would like to avoid reinserting the data. So basically we're wondering if there's a way to copy a table from one database to another. Thanks so much.

    ITKE346,430 pointsBadges:
  • Sequence information of mutltiple subforms in one form?

    I have one form embedded 3 subforms. I need to identify which subform is the top of the form because I need to write out the fields value to CSV in subsequently left top to right bottom as user can see on their PC.

    koseiarai5 pointsBadges:
  • SQL Server database: Checking which locks are held on table

    I know this an older version but I'm using SQL Server 2005 and I'm trying to check what database locks are applied on rows against a query batch. Is there some tool that will help me highlight table row level locking in real time? Appreciate the advice.

    ITKE346,430 pointsBadges:
  • What’s the best MySQL database field type for an URL?

    I've been trying to store an URL in a MySQL database but I'm running into an issue the field. What's the best way to define a field that will hold the URL for an undetermined amount of time. Thanks so much.

    ITKE346,430 pointsBadges:
  • How can I browse a SQLite database in Android

    I'm an Android user and I was wondering if there's a way to browse SQLite databases on my smartphone / view the data in the databases. I've been using SoftTrace but I was wondering if there was a mobile way to do it.

    ITKE346,430 pointsBadges:
  • Creating a new database with MySQL WorkBench

    I'm fairly new to the MySQL universe but I've recently installed MySQL Workbench and now I would like to create a database using it. How can this be done? I've noticed several "MySQL Schemas" being displayed in the Overview tab. Are those the existing datatbases? Thanks so much.

    ITKE346,430 pointsBadges:
  • Character limit for a column in an Oracle database

    I'm looking to store different postal codes in my Oracle database. I believe the column will be a VARCHAR2. I know the U.S. codes are 9 and Canadian codes are 7. Would 32 characters be efficient enough for the limit in the column? Or should I go higher? Thanks!

    ITKE346,430 pointsBadges:
  • Joining tables from a different SQLite database

    In one of my applications, I currently use a SQLite database and it's been working great. But I've been adding new functions and features so I'll need a second database and I'm having trouble with joining tables from a different database. How can I do this?

    ITKE346,430 pointsBadges:
  • MySQL database: Maximum number of records in a table

    For MySQL database, I was wondering what would be the maximum number of records I could add to a table. I was thinking of adding millions of of records to the table but I was wondering if there's a limit. What's the best way to handle this? Thank you.

    ITKE346,430 pointsBadges:
  • How to store images in a MongoDB database

    Would it possible to store images in a MongoDB database rather than just text? Should I create an array of images in the database? If that's possible, can I do the same for videos?

    ITKE346,430 pointsBadges:
  • Deleting all records from a database in a Ruby on Rails application

    How would I be able to delete all of my records, in one of my database tables on a Ruby on Rails application. I'm looking for a way not to do it through SQL.

    ITKE346,430 pointsBadges:
  • How can we store hours and minutes in a SQL Server database?

    My partner and I would like to store times in our SQL Server database but we only need to store hours and minutes. We already know we could use "DATETIME" and ignore the rest of the data but is there an easier way to do this? Thanks so much.

    ITKE346,430 pointsBadges:
  • How to encrypt a SQLite database

    I understand that Android uses SQLite database to store data but now I need to encrypt a SQLite database but I'm not sure how this can be done. What's the process to do so? My friend mentioned SQLCipher, would that work?

    ITKE346,430 pointsBadges:
  • Best database option for a .NET application

    My team is has been developing a small application with C# in .NET and we're looking to use a small light weight database (that doesn't use a ton of resources). What would be the best option for us?

    ITKE346,430 pointsBadges:
  • How to rename a MySQL database quickly

    How would I be able to rename a MySQL database quickly? Most of the time, I usually just dump the database and re-import it with a new name. But since this is a huge database, this isn't possible. Can anyone help me here?

    ITKE346,430 pointsBadges:
  • Can I do a MySQL dump by a SQL query?

    Can I do a "mysqldump" by a single SQL query? What I basically mean is that I want to dump the whole database. Thanks so much!

    ITKE346,430 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