BLYNK
HOME       📲 GETTING STARTED       📗 DOCS       ❓HELP CENTER       👉 SKETCH BUILDER

Curious about SQL and db.properties

#1

I have noticed the log file logs/postgres.log complaining about “db.properties file not found” and “Separate DB storage disabled”, and i think the idea of having blynk logging to SQL sounds pretty interesting but I haven’t found any documentation on the subject.

What am I missing?
How can I setup a connection from blynk to SQL (postgres) and what will this achieve?

0 Likes

#2

Hello, Why would you need DB? What is your goal?

0 Likes

#3

To be honest I don’t have a set goal :slight_smile:

But logging various values to the DB and then having other systems pick them up and act accordingly is one idea. I know CSV is possible but not as elegant.

If you know of any system that can act on status from blynk in any manner Im very interested :slight_smile:

I´d also like to take the time to thank you for this awesome project, It´s made it possible for me to take simple tasks, make them complicated with electronics and then making them simple again with blynk and learning tons on the way.

1 Like

#4

There is also http api for that.

You can easily integrate any 3-d party system with WebHook widget. No coding and no any setup :wink:.

Thanks!

In general we have no instruction for DB as it is hard for many users. Every additional instruction decreases 2 times the chance that user will setup server :slight_smile:. So we made as simple as it could be.

1 Like

#5

Thank you!

What is the current status for Push Notifications when running local blynk servern and using iOS devices. Still a no go?
(I understand this has been an apple problem and not blynk problem).

0 Likes

#6

Still no go. This is apple issue. Not ours. We can’t do nothing here :frowning:.

0 Likes

#7

But it works if I use your blynk server?

0 Likes

#8

Yes. If you mean Blynk cloud - yes.

1 Like

#9

Oki doki, thanks.
I guess I will have a look at the e-mail feature instead :slight_smile:

0 Likes

#10

You can also use email->sms via your operator. SMS notification for important alert?

0 Likes

#11

Nope, they stopped surrporting that years ago :frowning:

Wouldn’t it be possible to route the notifications from my blynk server to blynk cloud and then to apple? Or maybe that goes against 50 apples contract-rules?

0 Likes

#12

Use a general email to SMS gateway, they are pretty cheap as long as you are not receiving dozens of messages per day.

0 Likes

#13

This is possible. You are welcome to contribute :wink:

0 Likes

#14

You wouldn’t want my code trust me, but if I could donate to the project and make a feature request at the same time i´d be more than happy :slight_smile:

Out of curiosity, would apple charge to per notification or is it a fixed fee per year or something like that?

0 Likes

#15

It is free.

0 Likes