|
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.
|
|
|
|
|
You have two matching rows in the transaction table for each customer, and you've asked SQL to return all of them, so it's hardly surprising that you get two rows back per customer. If you only want the most recent transaction for each customer, there are ways to do that. However, it would help if you told us which DBMS you're using.
Also, try to avoid using old-style joins:
... FROM customer c,transaction t WHERE c.customer_id = t.customer_id And ...
Use an INNER JOIN instead:
... FROM customer c INNER JOIN transaction t ON c.customer_id = t.customer_id WHERE ...
It makes it much easier to separate the joining conditions from the filtering conditions, and to switch between different types of join.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Mysql database we are using.yes my transaction table is having two records per customer id, but paid amounts and other fields are different ,
but here the query is giving last record values for two records having same customerid.
Transaction table doesn't contain primary key,so there exists more than one record per customer id.
and i want most recent record from Database.
modified 3-Apr-14 3:41am.
|
|
|
|
|
I'm not overly familiar with MySql, but something like this should do the trick:
SELECT
...
FROM
customer c
INNER JOIN transaction t
ON t.customer_id = c.customer_id
INNER JOIN
(
SELECT customer_id, Max(paid_date) As LastPaid
FROM transaction
WHERE DATE(paid_date) BETWEEN '2014-02-02' AND '2014-04-02'
GROUP BY customer_id
) t2
ON t2.customer_id = t.customer_id
And t2.LastPaid = t.paid_date
;
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I guess it's safe to assume that it's monthly payments, and that BETWEEN '2014-02-02'AND '2014-04-02' you'd have two payments per customer_id.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
