Hi all, Firstly, this is not the question how to authenticate on email/password pair, but rather how to produce logical, and if you like, beautiful data structure. I want to use emails as user names in a given django project. However, I am unable to re-use fields provided by auth.User model for at least two reasons: auth.User.usernam...
NoSQL refers to non-relational data stores that break with the history of relational databases and ACID guarantees. Popular open source NoSQL data stores include: Cassandra (tabular, written in Java, used by Cisco WebEx, Digg, Facebook, IBM, Mahalo, Rackspace, Reddit and Twitter) CouchDB (document, written in Erlang, used by BBC and En...
I was wondering about size requirements for Tokyo Tyrant indexes. If I have an index on field x and insert a record with fields y and z only, does the x index grow? Also: does the insert time grow in that case? ...
Is there some kind of simple database system that uses simple text or xml files for data storage? I just need some basic functionality like update,delete, insert, simple constraints and relations. For the project that I have now using SQL Server would be too heavyweight and I have never really liked it anyway. ...
I am trying to insert into a access db and the PK is an autonumber that is generated by the DB. I am getting a syntax error for the insert statement and dont know why. If possible I would like to return the autonumber value in the same statement. Here is what I got so far. Dim cn As OleDbConnection Dim cmd As OleDbCommand D...
I'm upgrading an inventory system for a jewllery store that was originally built with MS Access. The application stores items, customers, vendors, and displays data about items stored. Reporting tool should be considered to generate reports for items in a printable format. The system should be built in C#, but I've not made the decisio...
I got a Nokia backup file (.cdb) - it's kindof database file. The first four bytes of the file are "DBFL". Is it a well-known database file? ...
I'm using delphi for years, but never for database stuff, but recently started researching and testing. I must say, i'm impressed, most of things happens automatically, i'm used to write by hand in php and python. i'm going to develop a commercial system for a friend, (2 layers) 5 user computers, 1 database server. Database server wi...
There are products, sections and attributes. Each attribute can have up to 5 or 6 options. Example: Power 10 Volt 15 Volt 20 Volt And there are about 10 products in total, each product has up to 17 attributes applied to it. Example: Product 1 power - 10 volt color - red, yellow link - online, offline How would you setup the tabl...
I made a model, and ran python manage.py syncdb. I think that created a table in the db. Then I realized that I had made a column incorrectly, so I changed it, and ran the same command, thinking that it would drop the old table, and add a new one. Then I went to python manage.py shell, and tried to run .objects.all(), and it failed, say...
Why can't I insert the word Español via the command line mysql program ? See session below. mysql> select CONCAT( 'Espa', 0xF1, 'ol' ); +------------------------------+ | CONCAT( 'Espa', 0xF1, 'ol' ) | +------------------------------+ | Español | +------------------------------+ 1 row in set (0.00 sec) mysql> crea...
kindly provide me with ans as quickly as possible ...
Hi All, After much reading, playing and fiddling, I am still not sure what ORM tool is the one i should be using above others.I am usign the Dotnet stack. I have looked at, Entity framework, LLBLgen Pro, NHibernate. Currenlty I am rather impressed with LLBLGen Pro. I have also read about Castle's active record, sub sonic and Linq to S...
I have to modify an existing table in a Oracle 10g DB with a few thousand records to add a surrogate autonumber key. One way that comes to my mind is to Create a new sequence Create the id column, allowing null values Updating the id column with the sequence Alter table to add "not null" and "primary key" for the new id column Is th...
Hi Folks, I am developing an application connecting to a database in Java. The customer has SQL Server and I tried the SQLExpress version von Microsoft as long as we don't want to buy a licence for the developement time. Sadly, the SQL Server Express does not allow network access so we can't work over network on the same database and ha...
I have four search fields that are used to search a database for book id:s and then echos out the result. Depending on wich field you choose to search from the sql query builds up as you can see in the code below. The title and isbn field are working fine but when I try to use the author or category field nothing gets returned. The relev...
I have a database in a server. Around 100 client PCs are connected to it from different locations. Now these clients are inserting data in this database within an interval of 10 seconds. Now what is the most efficient way to do this? I can open connection from every client pc to the server database. OR I can have a web service in the s...
i want to copy the structure (with the documents) from our vss server to an webserver. Therefore i want to create an application which is on this webserver. i want to use asp.net. i don't know what exactly i need therefore :> I have to build somekind of connection? then go throw the structure and copy it somehow :> ? important: i want...
This query is PAINFULLY slow and our team cannot figure out why. We've tried creating views, but it still extremely slow. Any thoughts? SELECT CI . CWARCASNBR AS CASENUMBER , CI . CT1FYA AS COURTAGENCYCODE , CI . CIPTYSQNBR AS PARTYSEQNBR , CI . CIRCDTYPE AS CASETYPECODE , CP . NMELASTBUS AS LASTNAME , CP...
Hello! Say I have 3 tables. Table1 contains client_id and client_name. Table2 contains client_id, client_catid_1, and client_catid_2. These to tables are joined based on the, client_id. Now the third table, contains category_id and category_name. How can join the third table based on the category id's and get the category_name? example...