Simplest SQL for Mac? - Database Discussion Boards

Re: MongoDB to Cache MariaDB?

Marco Bertschi9-Apr-14 7:55

Marco Bertschi

9-Apr-14 7:55

Jörgen Andersson wrote:
It's hard for me to believe that you could overload it with the use you specified earlier.

No, that isn't the problem I see - But later there might be a Web service in front of the DB, and many async write operations may deadlock SQLite - As you said, MariaDB is the way to go.

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

Re: MongoDB to Cache MariaDB?

Jörgen Andersson9-Apr-14 8:09

Jörgen Andersson

9-Apr-14 8:09

Ah, there you go, MariaDB it is then.

Wrong is evil and must be defeated.
- Jeff Ello[^]

Re: MongoDB to Cache MariaDB?

jschell10-Apr-14 9:05

jschell

10-Apr-14 9:05

Marco Bertschi wrote:
But later there might be a Web service in front of the DB,

Just noting that you seem to be suggesting that you can write both a client application and a web service application and somehow everything will be the same.

Although that can be done the complications involved are significant. Those complications seldom add anything to the functionality of either. And doing it successfully without prior experience is going to be a challenge as well.

Re: MongoDB to Cache MariaDB?

Eddy Vluggen9-Apr-14 6:52

Eddy Vluggen

9-Apr-14 6:52

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 Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: MongoDB to Cache MariaDB?

jschell10-Apr-14 8:57

jschell

10-Apr-14 8:57

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?

Re: MongoDB to Cache MariaDB?

Marco Bertschi10-Apr-14 9:40

Marco Bertschi

10-Apr-14 9:40

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

Re: MongoDB to Cache MariaDB?

jschell11-Apr-14 8:53

jschell

11-Apr-14 8:53

What is the expected average size? How many will there be? What is the estimated growth rate?

Simplest SQL for Mac?

Member 107310637-Apr-14 7:06

Member 10731063

7-Apr-14 7:06

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!

Re: Simplest SQL for Mac?

Jörgen Andersson7-Apr-14 8:33

Jörgen Andersson

7-Apr-14 8:33

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[^].

Wrong is evil and must be defeated.
- Jeff Ello[^]

Re: Simplest SQL for Mac?

Member 107310637-Apr-14 9:08

Member 10731063

7-Apr-14 9:08

Sounds like SQLite will work perfect, plus easy integration with PHP should make my life easy. Thanks a lot!

Mango database

Member 99929934-Apr-14 10:50

Member 9992993

4-Apr-14 10:50

Hello please i would ask you if you can help me there, thank you in advance

CSS

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,   // in milliseconds
    "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).

Re: Mango database

Richard Andrew x645-Apr-14 10:53

Richard Andrew x64

5-Apr-14 10:53

See: Mango DB[^]

The difficult we do right away...
...the impossible takes slightly longer.

Re: Mango database

Member 99929935-Apr-14 20:11

Member 9992993

5-Apr-14 20:11

Thank you for your advice but i need a bit help with code , can u please?

Re: Mango database

Chris Quinn7-Apr-14 0:12

Chris Quinn

7-Apr-14 0:12

You can start by asking the question only once

=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================

DB Mango

Member 99929934-Apr-14 10:50

Member 9992993

4-Apr-14 10:50

Hello please i would ask you if you can help me there, thank you in advance

CSS

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,   // in milliseconds
    "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).

Re: DB Mango

Mycroft Holmes4-Apr-14 14:12

Mycroft Holmes

4-Apr-14 14:12

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

Re: DB Mango

Jörgen Andersson4-Apr-14 23:53

Jörgen Andersson

4-Apr-14 23:53

Mycroft Holmes wrote:
I can only suggest you get into the documentation

Or the school books. Roll eyes | :rolleyes:

Wrong is evil and must be defeated.
- Jeff Ello[^]

Re: DB Mango

Simon_Whale7-Apr-14 1:17

Simon_Whale

7-Apr-14 1:17

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

Downgrade Sql server database

dilkonika4-Apr-14 9:07

dilkonika

4-Apr-14 9:07

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 !

Re: Downgrade Sql server database

Mycroft Holmes4-Apr-14 14:16

Mycroft Holmes

4-Apr-14 14:16

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

Re: Downgrade Sql server database

Andrius Leonavicius4-Apr-14 14:27

Andrius Leonavicius

4-Apr-14 14:27

You can't downgrade using a backup file. The only way is to use scripting:
How To Convert SQL Server 2008 Database To SQL Server 2005?[^]
or some comparison tools like Red Gates's SQL Compare and SQL Data Compare:
SQL Compare 10[^]
SQL Data Compare 10[^].

Search in textbox

Member 107240203-Apr-14 23:09

Member 10724020

3-Apr-14 23:09

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 .

Re: Search in textbox

Richard Deeming4-Apr-14 0:59

Richard Deeming

4-Apr-14 0:59

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

How to write stored procedure in mysql workbench. SELECT, INSERT, UPDATE,DELETE

Ravi900kumar3-Apr-14 10:28

Ravi900kumar

3-Apr-14 10:28

<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`)
)

Re: How to write stored procedure in mysql workbench. SELECT, INSERT, UPDATE,DELETE

PIEBALDconsult3-Apr-14 10:41

PIEBALDconsult

3-Apr-14 10:41

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.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.