Fastest database?
I am looking for fastest free key-value pair database available. Database doesn't have to be server-based, it can be linked into the application. I am aware of Tokyo Cabinet. Any other suggestions? ...
database
Specail Character not accepted by DB
Hi, I want to add G:tech work in my table columm but my system is giving special characters are not allowed, We are using SQL server could you please help me who to insert this word in DB and why it is not taking specail characters?? ...
Why wont this sort in Solr work?
I need to sort on a date-field type, which name is "mod_date". It works like this in the browser adress-bar: http://localhost:8983/solr/select/?&q=bmw&sort=mod_date+desc But I am using a phpSolr client which sends an URL to Solr, and the url sent is this: fq=+category%3A%22Bilar%22+%2B+car_action%3AS%C3%A4ljes&version=1....
How can I detect the day of the week and the time, and then display data in a tableview based on the current day and time?
I have a list of data that is a schedule. Each item has a time that it takes place in. I want to detect the current day and time and then display what items are available during that time. All I really know is how to get todays date and time and that I need to create a method to look in my data at what is currently "playing". Any sug...
Winforms: How to upload a picture into SQL Server database using C#
I want to upload images to my SQL Server database. I have two buttons , One picture box. With the browse button, I am able to select the file from disk, and it is displayed into the picturebox. The problem is that I am not able to save the picture from picturebox into the database. Please help me out with the code. Appreciate it. ...
WPF container for Image template
Hi, I'm storing the urls to the images in a sql ce 3.5 database as strings. I want to retrieve the urls and display them in the main application window. Here is the code: DataSet myDataSet; private void OnInit(object sender, EventArgs e) { string connString = Properties.Settings.Default.SystemicsAnalystDBCo...
Does using the "Microsoft Text Driver" require the use of a schema.ini file?
Using C#, I'm trying to create a form with a dataGridView that shows the contents of a fixed width, flat file database. Does using the "Microsoft Text Driver" require the use of a schema.ini file? Below is the connection string I'm using. I cant seem to get the grid to fill regardless of whether I use one or not but I'm not sure if I eve...
Backup remote SQL Server 2005
How do I backup data from a remote MS-SQL Server DB to my local computer? I'm having access to Management Studio 2008. ...
Help regarding database driver connection through gwt
Hello guys so i am just getting to terms with using gwt and the rpc services that i can implement. So i began with the gwt greeting service started project.(all gwt users know this starter app) all i wanted to do was to press the send button on the web page. it would retrieve a simple string from my database and display it on the webpa...
How to use Access database with query as pivot table in Excel
I want to use Access database with query for pivot table in Excel. How do I do that? ...
Speeding up bulk inserting in SQL Server 2005
Is there any way to speed up bulk inserting in 2005? I'm looking into partitioning, is it good? ...
NULL Characters in Firebird VARCHAR
Hello there, Im trying to find records in a VARCHAR column that may contain a NUL (0x00), and I cannot find a way to locate the NUL character. Any ideas are welcome. -Israel ...
Storing connection in a static class (ASP.NET)
Since I'm using Postgresql and can't use LINQ to SQL, I wrote my own wrapper classes. This is a part of the Student class: public class Student : User { private static NpgsqlConnection connection = null; private const string TABLE_NAME = "students"; public int Id { get; set; } public string FirstName { get; set; } ...
sqlite: trouble selecting by real values
Hello, I am using an sqlite database to store log data. My table has a lot of 'real' type columns. When I try to execute queries like: SELECT * FROM log WHERE SomeNumber = 61; SELECT * FROM log WHERE SomeNumber='61'; It will return nothing. Queries like: SELECT * FROM log WHERE SomeNumber < 10 SELECT * FROM log WHERE SomeNumber > ...
Sqlalchemy - Can we use date comparison in relation definition ?
Hi, I have this mapper defined: mapper(Resource, resource_table, properties = {'type' : relation(ResourceType,lazy = False), 'groups' : relation(Group, secondary = model.tables['resource_group'], backref = 'resources'), 'parent' : relation(Relation, uselist=False, primaryjoin = and_(relation_table.c.res_id == resourc...
ADO.NET DataSet with Parent-Child tables foreign key error
I have a parent table and child table and I would want to insert into them using a dataset/datatable/dataadapter combination. Inside the SQL Server database the parent table is declared with a primary key, and the child table with a foreign key -- the primary of the parent. One entry in the parent table could potentially have 0->n entrie...
Restricting number of rows
I want to restrict the maximum possible rows that can be inserted in the table. Is it possible to have such constraint in database ? ...
How to alter a column datatype for derby database?
Hi, I am trying to alter a datatype for a derby db column. The current price column is set as DECIMAL(5,0). I would like to alter it to DECIMAL(7,2). I did this : alter table item alter column price set data type DECIMAL(7,2); But it did not work, and showing the error: Error: Only columns of type VARCHAR may have their length alte...
Do DB indexes take same amount of disc space as column data?
If I have a table column with data and create an index on this column, will the index take same amount of disc space as the column itself? I'm interested because I'm trying to understand if b-trees actually keep copies of column data in leaf nodes or they somehow point to it? Sorry if this a "Will Java replace XML?" kind question. U...
MySQL: low cardinality/selectivity columns = how to index ?
Hello Experts, I need to add indexes to my table (columns) and stumbled across this post: http://stackoverflow.com/questions/141232/how-many-database-indexes-is-too-many Quote: “Having said that, you can clearly add a lot of pointless indexes to a table that won't do anything. Adding B-Tree indexes to a column with 2 distinct values...