database

Creating Database in ActionScript

I am beginner of AS3 and I want to make a xml file retiring and saving the data through as3 program without using PHP. ...

Wiki Database, is there one?

I was searching the net for something like a wiki database, just like wikipedia but instead stores structured content, editable by users. What I was looking for was an online database accessible by everyone where people can design the schema and data with proper versioning of both schema and data. I couldn't find any such site. I am not ...

Can anyone recommend a synthetic data generator?

Did anyone come across a free data generator that ca create synthetic data to load into databases for testing purposes? ...

Simple multi-user database solution

I've written a Windows desktop application that works with Sqlite very nicely. It was a single user app, and the database sits right on the machine where the app runs. However, the application has grown, and now multiple users should be able to run the app and connect to one shared database. I'd like to just be able to share the sqlit...

Save in database didn't work ?! (VB.NET | OLE)

Hello ,, I used the following code to save what the user editing , the code don't give me any error code , but in the same time it don't do any thing , the data still without any new changes : Dim a As String a = comb3.Text & "/" & comb2.Text & "/" & comb1.Text Dim SavInto As New OleDb.OleDbCommand Dim ConStr A...

Django - Populating a database for test purposes.

I need to populate my database with a bunch of dummy entries (around 200+) so that I can test the admin interface I've made and I was wondering if there was a better way to do it. I spent the better part of my day yesterday trying to fill it in by hand (i.e by wrapping stuff like this my_model(title="asdfasdf", field2="laksdj"...) in a b...

How do I migrate data from one model to another using South in Django?

I created a Django app that had its own internal voting system and a model called Vote to track it. I want to refactor the voting system into its own app so I can reuse it. However, the original app is in production and I need to create a data migration that will take all the Votes and transplant them into the separate app. How can I ...

[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error - connecting to SQL database in VB script

I have a VB script which connects to a local SQL database to retrieve a value. The exact same script runs on about 100 servers, but a few of the servers produce this error: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation Here is the code that runs: Function GetPrimaryServerID On...

Database versioning

Hi everyone, I have made few projects (CMS and EC system) that required to have some data versioned. Usually I come with that kind of schema +--------------+ + foobar + +--------------+ + foobar_id + + version + +--------------+ it worked great but I am wondering if there is a better to way do it. The main problem wi...

Android Web Access to Database?

I would like to ask you smart people if anyone has seen any documentation regarding web access to a database from within an Android application. I would like to create a (FREE) application where the users can share information (rants/complains) around the globe. Each user will be able to see a little globe in his phone with locations of ...

Connect with a database over the LAN

How to connect with a database over the LAN? I have only the name of the computer. ...

what are the fastest/Popular search technologies

What are the fastest search technologies apart from Relational DB Searches ? I have a collection of Text Files from varied sources (Banks/Ledgers/Stock Markets). Each line in these Text Files is a Record. Each line can further be parsed into some DB Columns(Stock Name/Date of purchase/Owner/...). It is not necessary that each line has a...

select most popular tags from database?

i have 2 tables linked together through the 3rd table threads: id, name tags: id, name thread_tag_map: threads_id, tags_id its a many to many relationship. i want to select 30 tags that are most popular that is to say the first 30 tags with tags_id which occur the most in thread_tag_map. i think you understand my question (and sorry ...

Suitable design for a database application

Hi, I have a question related to a web app that I developed in PHP, MYSQL. basically part 1 is : I display results in the form of table say for software testing. ID Prod_Name Set Date Result Platform 1 Alpha1 Pro1 01.01.01 PASS 2.3.1.2_OS Now, I have divided the tables accordingly Table Name: Result...

Saving order preference in SQL

I am trying to see what is the best way to handle the following scenario I have a table called, lets say User, and i have a table called items. Each user can have multiple items added to his account. I have another table , lets say AssociateItem, which maintains the association between user and the items. (links UserID to ItemID). A us...

PHP and mod_dbd

Does anyone know a PHP extension to use mod_dbd for database connections? Our application needs to access a remote database. It used to be an Apache module using mod_dbd for database connections and the transaction takes about 200ms. Now we changed the application to PHP and the same transaction takes over 600ms now. We hope some kind o...

Storing Images in DB - Networked Desktop Applications

Related: Storing Images in DB - Yea or Nay? After reading the above question, it seems the preferred method for image storage with databases is to store only the filepath within the database. However, most of these answers seem to focus on web servers. In my case, I'm developing a desktop application that will be used across mult...

Help designing database for a twitter web application

Hello. I'm trying to create a small website in ASP.NET MVC that uses twitter. I want to be able to pull some information about twitter users and store it in a database, which I will update periodically. I am using the following tables: Users user_id - uses the twitter id (int) twitter_name - nvarchar(255) last_updated - datetime Tw...

can this be written with an outer join

The requirement is to copy rows from Table B into Table A. Only rows with an id that doesn't already exist, need to be copied over: INSERT INTO A(id, x, y) SELECT id, x, y FROM B b WHERE b.id IS NOT IN (SELECT id FROM A WHERE x='t'); ^^^^^^^^^^^ Now, I was trying to write this with an outer join ...

Fogbugz database schema management

This is a very simple question, and maybe the man himself can provide insight on this :) Does anyone know the pseudocode behind how Fog Creek does database schema management? I'm running into an issue and I'm trying to figure out if I'm handling it right... I have a module that runs each time someone spins up their site and examines th...