Go Down

Topic: need to store data in database. (Read 3206 times) previous topic - next topic

jonyjakee


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.

PaulS

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.

jonyjakee

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.

PaulS

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.

Jack Christensen

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.
MCP79411/12 RTC ... "One Million Ohms" ATtiny kit ... available at http://www.tindie.com/stores/JChristensen/

jonyjakee

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.

PaulS

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.

jonyjakee


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

Jack Christensen



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.
MCP79411/12 RTC ... "One Million Ohms" ATtiny kit ... available at http://www.tindie.com/stores/JChristensen/

jonyjakee


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.

m_ri

#10
Jul 03, 2012, 08:19 pm Last Edit: Jul 03, 2012, 08:21 pm by m_ri Reason: 1
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)

jonyjakee


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.

CatweazleNZ

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

JimboZA

Quote
If you want to sneaker-net the data around


Now, there's a term I haven't heard for a decade or two....
My hovercraft is full of eels.

No PMs for help please.
DO NOT power servos from Arduino 5V: give them their own power and connect the grounds.

Erni

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

Go Up