Pages: [1] 2   Go Down
Author Topic: need to store data in database.  (Read 2915 times)
0 Members and 1 Guest are viewing this topic.
Offline Offline
Newbie
*
Karma: 1
Posts: 46
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset


i am trying to work with ethernet shield with sd card.

i need to use the database to store my datas.

Is it possible to  use the database in storing my datas in the sd card.

Please help me with the simple sample programs.
Logged

Seattle, WA USA
Offline Offline
Brattain Member
*****
Karma: 654
Posts: 50931
Seattle, WA USA
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Quote
i need to use the database to store my datas.
What database?

Quote
Is it possible to  use the database in storing my datas in the sd card.
What database? A relational database consists of a lot more than just data storage.

Quote
Please help me with the simple sample programs.
There are simple samples (provided) for reading and writing to SD cards. Creating a database application that uses the SD card as the data repository is possible but not simple.
Logged

Offline Offline
Newbie
*
Karma: 1
Posts: 46
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Quote
What database?

i am planning to use SQL for data base.

I am planning to send data from android mobile and it should receive in router to eternet shield and it shold store the data in the exact tables in the data base.

Is the things possible.
Logged

Seattle, WA USA
Offline Offline
Brattain Member
*****
Karma: 654
Posts: 50931
Seattle, WA USA
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Quote
i am planning to use SQL for data base.
SQL stands for Structured Query Language. It is not specific to any particular relational database.

Quote
I am planning to send data from android mobile and it should receive in router to eternet shield and it shold store the data in the exact tables in the data base.

Is the things possible.
Not unless you intend to develop a relational database program for the Arduino. Doing so in 32K of program space with 2K of SRAM will be a real challenge.
Logged

Grand Blanc, MI, USA
Offline Offline
Faraday Member
**
Karma: 95
Posts: 4095
CODE is a mass noun and should not be used in the plural or with an indefinite article.
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

I like to say that anything is possible, given enough time and money, but an Arduino is probably not going to be capable of running an SQL database. Given that, I don't see a need for an Arduino at all from the rather brief description here. Just have the Android device send the data directly to the database server and cut out the middle-man.
Logged

MCP79411/12 RTC ... "One Million Ohms" ATtiny kit ... available at http://www.tindie.com/stores/JChristensen/

Offline Offline
Newbie
*
Karma: 1
Posts: 46
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Quote
SQL stands for Structured Query Language. It is not specific to any particular relational database.

i am new to relational database. Do you have any sample program for the relational database.

Quote
Not unless you intend to develop a relational database program for the Arduino. Doing so in 32K of program space with 2K of SRAM will be a real challenge.

i luv challenge. You are making me interested in this. But i need help too.
Logged

Seattle, WA USA
Offline Offline
Brattain Member
*****
Karma: 654
Posts: 50931
Seattle, WA USA
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Quote
Do you have any sample program for the relational database.
MySQL, Postgre/SQL, SQLServer, etc. are all examples of relational databases.

Quote
i luv challenge. You are making me interested in this. But i need help too.
Including realistic expectations.

You are probably better off figuring out how to use individual flat files as substitutes for each table.
Logged

Offline Offline
Newbie
*
Karma: 1
Posts: 46
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Just have the Android device send the data directly to the database server and cut out the middle-man.

I am in a need to store the datas in a external storage device. so i prefer sd card in ethernet shiled with sql or any data base
Logged

Grand Blanc, MI, USA
Offline Offline
Faraday Member
**
Karma: 95
Posts: 4095
CODE is a mass noun and should not be used in the plural or with an indefinite article.
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

Just have the Android device send the data directly to the database server and cut out the middle-man.

I am in a need to store the datas in a external storage device. so i prefer sd card in ethernet shiled with sql or any data base

Isn't a database server an external storage device? If you want to sneaker-net the data around, then download it from the database to a flash drive.
Logged

MCP79411/12 RTC ... "One Million Ohms" ATtiny kit ... available at http://www.tindie.com/stores/JChristensen/

Offline Offline
Newbie
*
Karma: 1
Posts: 46
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

then download it from the database to a flash drive.

can you send me a simple web sever sketch in ethernet with sd card storage in it.
Logged

Offline Offline
God Member
*****
Karma: 9
Posts: 550
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

I think that is impossible process sql instruction directly from Arduino,without database server(or a pc)..for example sqlite library,which is a very small implementation of sql ,requires more than 100kb..
In my opinion,u have two option:
- Use a flat file(like .dat,.txt,.csv) on the sd card
- use a database server installed in some pc(or also in a router with openwrt,if is possible),the Arduino could build the SQL string and pass them to the pc..but it required ethernet shield(or other type of conection)
« Last Edit: July 03, 2012, 01:21:46 pm by m_ri » Logged

Offline Offline
Newbie
*
Karma: 1
Posts: 46
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

In my opinion,u have two option:
- Use a flat file(like .dat,.txt,.csv) on the sd card
- use a database server installed in some pc(or also in a router with openwrt,if is possible),the Arduino could build the SQL string and pass them to the pc..but it required ethernet shield(or other type of conection)

Please send me a sample code which accesses the data from the client side in this ethernet and router connection.
Logged

Offline Offline
Full Member
***
Karma: 2
Posts: 123
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

In 1995 when using Turbo Pascal I wrote a simple relational database similar to the dBase/Paradox form where every table and every index uses a separate physical file.

Having worked with an Ethermega card for some months my 5,000 plus line home automation system has been pushing RAM limits for some time, primarily because of application data stored in arrays in RAM. Of course all the data is written out to log files everyday to build up a long term history - but once out of Arduino RAM all that data no longer participates in application functionality/reporting,

With ample Flash and SD card memory/space remaining it might be time to throw my data out of the Arduino's RAM and store it in a simple relational database on my SD card. I have found my old 1995 code - maybe over the next few months I will port it to Arduino C. Still just a idea - but at least I have a proven working model to start with.

It seems that an Ethermega card with plenty of flash (256KB - I am only using 100KB so far), only 8KB RAM, 4KB EEPROM (2KB used for strings) and access to say 4GB SD card storage is actually a development environment begging for a simple relational database tool/library for large data storage and reporting.

Or should an Intel Galileo be my next step? Does it support massive amounts of array RAM data?

Catweazle NZ
Logged

Johannesburg. UTC+2
Offline Offline
Faraday Member
**
Karma: 114
Posts: 4982
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Quote
If you want to sneaker-net the data around

Now, there's a term I haven't heard for a decade or two....
Logged

The Elders of the Internet know who I am
I'm on LinkedIn: http://www.linkedin.com/in/jimbrownza

Denmark
Offline Offline
Edison Member
*
Karma: 37
Posts: 1096
Happy Hobbyist
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

Quote
Or should an Intel Galileo be my next step?

You could choose the Arduino Yun to stay in the family, or a RPI, both are capable of running MySql or SQLite
Logged

Pages: [1] 2   Go Up
Jump to: