next topic »

[on:]

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.

[Reply #1 on:]

i need to use the database to store my datas.

What database?

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.

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.

[Reply #2 on:]

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.

[Reply #3 on:]

i am planning to use SQL for data base.

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

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.

[Reply #4 on:]

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.

[Reply #5 on:]

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.

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.

[Reply #6 on:]

Do you have any sample program for the relational database.

MySQL, Postgre/SQL, SQLServer, etc. are all examples of relational databases.

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.

[Reply #7 on:]

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

[Reply #8 on:]

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.

[Reply #9 on:]

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.

[Reply #10 on:]

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)

[Reply #11 on:]

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.