• 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?

    ITKE351,335 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?

    ITKE351,335 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!

    ITKE351,335 pointsBadges:
  • How to find all occurrences of a URL in a MySQL database

    A friend of mine has been having trouble dealing with his MySQL database. He's been trying to locate all occurrences of a URL in the database but he doesn't know where to start. He wants to search all of the tables / fields. Appreciate the help.

    ITKE351,335 pointsBadges:
  • What’s the best way to store tags in a database?

    My teams is in the process of implementing a tagging system on our website but we have a big question: What's the most efficient way to store the tags in a database, so they can be searched and filtered? We've come up with this so far: Table: Items Columns: Item_ID, Title, Content Table: Tags...

    ITKE351,335 pointsBadges:
  • How can we check if a MySQL database exists?

    Can anyone tell me if it's possible to check if our MySQL database exists after we've made a connection? We already know how to check if a table exists in our database but now we need to see if the actual database exists. Thanks!

    ITKE351,335 pointsBadges:
  • Importing a web page to a database

    How we can import a web page (the full content of the web page) into the particular database? That means you create your own search engine and storing the web page in to the created search engine database.

    ptnaveenraj20 pointsBadges:
  • What’s the best way to create flat file database structures?

    Would anybody be able to share some of the best ways / practices for creating flat file database structures in PHP? From what my partner and I have learned, these frameworks are more of ways to implement SQL-like query syntax. We were also told SQLite is the way to go here. Is that true? Thanks so...

    ITKE351,335 pointsBadges:
  • Deleting and creating databases in Neo4j

    Would it be possible to delete / create several databases in Neo4j (like MySQL)? If I can't do that, would I be able to delete all the nodes / relationships of an existing graph so I can get a clean setup for testing? Thanks so much.

    ITKE351,335 pointsBadges:
  • How to duplicate MySQL database

    Would it be possible for me to duplicate my entire MySQL database on a Linux server? I already know I can export / import but the database has over 25 MB so it's not the best solution. Can I use "MySQLdump" or just directly duplicate the database files?

    ITKE351,335 pointsBadges:
  • How to rename a MongoDB database

    I just realized there's a typo in my MongoDB database name and I need to change the name ASAP. I've tried to copy and delete it like this: db.copyDatabase('old_name', 'new_name'); use old_name db.dropDatabase(); Would there be a command to rename it?

    ITKE351,335 pointsBadges:
  • VB.NET code to search if a record already exists or not

    Hi! I need a fresher..I want a VB.net code to search record from SQL database table by using two fields of table as a condition i.e client name and client code before saving any new record and if record already exist in table it give me message for that. I'm sending you the code. Please help...

    Sachinm10 pointsBadges:
  • Would I be able to merge multiple SQLite databases?

    I currently have a large number of SQLite databases (that all have the same schema). Is there a way I can merge them altogether so I can perform a query on all the databases? I thought I could use "ATTACH" but I found out it has a limit of 32 / 64 databases (depending on the memory system). Can...

    ITKE351,335 pointsBadges:
  • How to drop a table in Ruby on Rails database

    In my database, I've added a table that I thought that I was going to need but I don't need to use it anymore. Is there a way to remove that table? I've run several migrations already so the table is in my database. I thought this would handle it but I'm not sure: rails generate migration...

    ITKE351,335 pointsBadges:
  • Can I version my SQL Server database?

    I'm trying to get several of my SQL Server databases under version control. Would anybody have some advice on how I should do this? Basically, I'll want a large collection of generated test data for performance management. Thanks so much!

    ITKE351,335 pointsBadges:
  • What is a data warehouse and how can it benefit organizations?

    I need to know how do I create a star schema for the data warehouse to accommodate the information below: A data warehouse is required to accumulate information on the rental market in London. It will hold information on landlords and tenants (names), houses (no of rooms, type of housing (e.g....

    josenunes5 pointsBadges:
  • Moving SQL Server database without affecting VB 6 code

    I am using VB 6 code with Microsoft Access database. Now I want to move to SQL Server 2008 database without affecting my VB 6 code. Any suggestions?

    vikasjains20 pointsBadges:
  • Cascading combo boxes in Microsoft Access database

    I am a Continuing Education Teacher and I have been asked for help in building a function in a Microsoft Access database. I must say I have not yet found a solution. So, here what is needed: “I have constructed a contacts and networking database that I use to gather information on my professional...

    lawantyson5 pointsBadges:
  • How to access multiple records at a time in DBMS

    I want to access multiple records at a time in DBMS.

    jaimeen5 pointsBadges:
  • FXP FILES CONVERSION (TO PRG FoxPro program)

    fOXPRO REL 2.6 (FOR dos) CAN SOMEBODY GUIDE ME AS TO HOW FXP FILES ARE CONVERTED BACK TO PRG (WITHOUT SPENDING MONEY) ?

    TomLiotta125,585 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