|
Marco Bertschi wrote: It will be, since a user may run more than one instance of the software Doesn't "have" to be; there might as well be a Windows-service that works as a DAL - and have your app interface with that.
Still, for multiple users one would recommend a *server*-database, complete with a server. It'd be a bit overkill to add that functionality yourself. And yes, that will introduce network-latency, but still does not mean that you need a second server-instance at the client.
Store cache the static data locally; that'd be the pictures. Generate a hash to see what's modified. Put the relational info in the server, and access that without caching. Lots of webapps have a webservice-layer on top of that DB and perform decent - so I'd assume that any app querying directly would be faster. You could then omit the client-db completely and cache the images on the filesystem.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Marco Bertschi wrote: Since I will store big amounts of data
Where "big" means that the image size is 100 gigs or 100k? And there are 1 billion images or 1000? What is the projected growth rate?
Marco Bertschi wrote: I I'm in doubt whether the MongoDB will really give me any performance boosts
What makes you think that you need a performance boost? How many requests does your business model realistically require per second? What is the distribution of the type of requests within an average hour?
|
|
|
|
|
jschell wrote: Where "big" means that the image size is 100 gigs or 100k? And there are 1 billion images or 1000? What is the projected growth rate?
"Big" in relation to a single entry in a table - A single RAW image can easily add up to more than 10 MB (which is big in comparison to other data, e.g. plain text)..
I will never again mention that Dalek Dave was the poster of the One Millionth Lounge Post, nor that it was complete drivel.
How to ask a question
|
|
|
|
|
What is the expected average size? How many will there be? What is the estimated growth rate?
|
|
|
|
|
Greetings,
I'm looking to create a basic DB for my small media production business. Think content similar to old Northwind DB. Were my partner and I both using Windows, I would just use Access but I use Mac so that is not an option other than using Bootcamp which I would rather not do.
I was looking at MySQL and PostgreSQL and not sure which to select. Pros/cons etc. I'm looking to hopefully store the DB online on my web server and create an Objective-C (Cocoa) app or web app (PHP?) to query, insert, update etc. (I know this is DB forums, just giving context). Let me know if clarification is needed.
Thank you!
|
|
|
|
|
There's always Filemaker as a fairly close substitute for Access, having more or less the same drawbacks. So nothing I personally would recommend.
If an embedded database is enough for you can check out on this[^] page if SQLite is good enough for you.
If you indeed need a "real" database you can read a concise but good comparison between MySQL and PostgreSQL here[^].
|
|
|
|
|
Sounds like SQLite will work perfect, plus easy integration with PHP should make my life easy. Thanks a lot!
|
|
|
|
|
Hello please i would ask you if you can help me there, thank you in advance
if we have two dataset 1-First dataset contains population data of cities in the United States of America. Each record in the dataset has the following format:
{
"city": "ACMAR",
"loc": [
-86.51557,
33.584132
],
"pop": 6055,
"state": "AL",
"_id": "35004"
}
Second dataset contains log data from a geo-locational service. Each record in the dataset has the following format:
{
"_id": {
"$oid": "5191f53b1b76a5666a8cbd64"
},
"status": 200,
"requrest_time": 504,
"type": "stationboard",
"datetime": {
"$date": "2014-02-19T07:03:32.000Z"
}
}
1-how we can Get all the states that have at least 2 cities with population > 1000000 (1M).and we need to Remember that city can be splitted into multiple records, and we should aggregate its population first. (zips dataset)
2- we need Find a day (date) with the largest number of HTTP 500 errors (status=500).
|
|
|
|
|
See: Mango DB[^]
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
Thank you for your advice but i need a bit help with code , can u please?
|
|
|
|
|
You can start by asking the question only once
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
Hello please i would ask you if you can help me there, thank you in advance
if we have two dataset 1-First dataset contains population data of cities in the United States of America. Each record in the dataset has the following format:
{
"city": "ACMAR",
"loc": [
-86.51557,
33.584132
],
"pop": 6055,
"state": "AL",
"_id": "35004"
}
Second dataset contains log data from a geo-locational service. Each record in the dataset has the following format:
{
"_id": {
"$oid": "5191f53b1b76a5666a8cbd64"
},
"status": 200,
"requrest_time": 504,
"type": "stationboard",
"datetime": {
"$date": "2014-02-19T07:03:32.000Z"
}
}
1-how we can Get all the states that have at least 2 cities with population > 1000000 (1M).and we need to Remember that city can be splitted into multiple records, and we should aggregate its population first. (zips dataset)
2- we need Find a day (date) with the largest number of HTTP 500 errors (status=500).
|
|
|
|
|
Ah MongoDB is one of these new fangled document databases and does not use SQL, I can only suggest you get into the documentation. Most of us use traditional relational database and can help with SQL queries.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: I can only suggest you get into the documentation
Or the school books.
|
|
|
|
|
A Quick Google shows me this one as the top reference
SQL Comparison for Mango DB[^]
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
Is there any utility or mode to convert a sql server database to a lower version.
For example From sql server 2008r2 to sql server 2005 ?
Thank you !
|
|
|
|
|
No, if you have not used any of the version specific functionality in the 2008 DB you could script out the database and use something like Red-Gate Compare and Data Compare to move the data across.
Also I think you can set the compatibility on the server, that may help.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
Hello,
I created table and loaded it on data-grid view.
MySqlCommand cmddatabase = new MySqlCommand("select number as 'رقم', date as'تاريخ ',name as (أسم);", condatabase);
Now i want search on the name from textbox. So i did like this
private void txt_in11_TextChanged(object sender, EventArgs e)
{
DataView dv = new DataView(dbdataset);
dv.RowFilter = string.Format(" 'name' LIKE '%{0}%'",txt_in11.Text);
dataGridView1.DataSource = dv;
}
My problem when i search on the name nothing appear in the table. it appear is clear although i inserted in the table some rows.
So please can any one help me in this .
|
|
|
|
|
Your DataView doesn't contain a column called "name"; it contains a column called "(أسم)".
Either change your RowFilter to match the column alias, or change the column alias to match your RowFilter .
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
<b>How to write stored procedure in mysql workbench. SELECT, INSERT, UPDATE,DELETE</b>
create table `admin_sales`(
`sales_id` int(10) unsigned NOT NULL auto_increment,
`sales_name` varchar(500) NOT NULL,
`sales_father_name` varchar(500) NOT NULL,
`sales_mobile_no` varchar(20) NOT NULL,
`sales_date_of_birth` varchar(50) NOT NULL,
`sales_date_of_joining` varchar(50) NOT NULL,
`sales_present_address` varchar(500) NOT NULL,
`sales_area` varchar(100) NOT NULL,
`sales_city` varchar(100) NOT NULL,
`sales_state` varchar(100) NOT NULL,
`sales_country` varchar(500) NOT NULL,
`sales_pin_code` varchar(50) NOT NULL,
`submission_date` DATETIME ,
`modified_date` DATETIME ,
`modified_by` varchar(100) NOT NULL,
PRIMARY KEY (`sales_id`)
)
|
|
|
|
|
I'd use a text editor. But why would you want to do that anyway?
You'll never get very far if all you do is follow instructions.
|
|
|
|
|
Hello every body , please i need your help with Mango db , i am new with mango , so please if some body of you have already experience , please MSG me .
Thank you in advnce
|
|
|
|
|
That is not how the forum works, there are a bunch of volunteers who try and answer SPECIFIC question on a subject. Maybe you can get a book on MangoDB.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
hi,
I need to select data from two tables am using the following query:
select c.customer_id ,c.father_name ,c.address,c.phone_number ,c.mobile_number ,c.id_proof ,c.area ,c.ip_address as 'IP Address',c.mac_address as 'MAC Address',c.package_type as 'Package Type',c.name as Name,c.activation_date as 'Activation Date',c.status as 'Status',c.installation_cost as 'Installation Cost',c.totalamount_paid as 'Total Amount Paid',c.monthly_amount as 'Monthly Amount',c.lastpaid_date as 'Last Paid Date',c.lastpaid_amount as 'Last Paid Amount',c.nextpay_date as 'Next Pay Date',c.totaldue_amount as 'Total Due Amount',t.agent_id as 'Agent ID',t.token_number as 'Token Number',t.machine_id as 'Machine ID' from customer c,transaction t where c.customer_id=t.customer_id and DATE(t.paid_date)BETWEEN '2014-02-02'AND '2014-04-02' ;
It's giving correct information but each record is displayed twice , i want a record only once.
|
|
|
|
|