-3

i'am just learning about raspberryPi. how can i communicate raspberryPi with database, so that can raspberryPi send message/sms using gsm module?? and how the Raspberry Pi read databases mysql from different tables that could be sent in a single sentence using gsm? I hope any suggestion given to me from friends in here Thanks

adew
  • 1
  • Nice try @adew. What the down-voting people did't do was to tell you why. I spent some time trying to answer your questions & also given you some advice for the future. I suggest you read all of it. So keep asking questions. I know the next one you ask will be great! – David Bern Mar 14 '17 at 08:30

1 Answers1

1

Nice first question adew!

To improve the next future question you make please read: https://stackoverflow.com/help/how-to-ask

I will take the time to try answer your question, because I suspect that there is more people out there with the same ideas as you.

To start with

GSM module communication:

This question has many different answers and the answer depends on what hardware you will use. There is no standard in this area.

To give you some options;

Sparkfun will provide you with a detailed datashet & Adafruit even has a detailed tutorial. The drawback with the Adafruit tutorial is that it assumes that you are using a arduino (Not a big problem)

Both of the above modules are capable of UART communication, something you easily can access with a RaspberryPI and

Personally I have used WiringPI before and it is easy to start with and has a bunch of active maintainers on IRC.

To wrap up the GSM-part. Consult the manual for that particular device you are going to use. That is the only way you will know what to send and what you will receive from the module.

Database querys:

Are you using a existing database or are you going to create your own from scratch? Even that part of the question is to broad.

If you are going to make a new database just for this kind of application I might suggest using

It will give you a nice little ORM tool. It will make it easy for you to insert and fetch data that probably matches how you want to work with the data.

If the database is a existing MySQL database

Well again, consult the manual.

To wrap this up.

This was a very lengthy post, that gave you almost nothing about almost everything. This is why people down-votes a questions like the one you made. Most people dont have the time to give this kind of answers.

I suspect that the next question you make will be related to any of the above topics.

  • Try to be precise
  • Give a piece of code that exposes the problem you have
  • One problem at a time

Happy hacking & have a look at https://raspberrypi.stackexchange.com/ !

//David Bern

Community
  • 1
  • 1
David Bern
  • 778
  • 6
  • 16