I started to learn code some years ago. First I learned html and css which most don't really consider as coding. I then started to experiment with php, javascript, python,.... I managed to create some websites and even some applications but I'm not a programmer and what I do is amateurish at most.
My experiences with databases
I used to be quite good with Microsoft access. I learned the program with a book, out of necessity. I was the director of a language school and we had no software to manage our business. So I created the software myself with access. I left the company about 11 years ago and they still use the software I created. It wasn't perfect but it really helped to simplify and automatise a lot of administrative tasks.
Coding and databases – my security nightmare
You could think that knowing how to code and how to deal with databases, it would have been a child play for me to combine the two. Well that's where you are wrong, at least in my case. I never managed to link the two together. Mainly because I realised how easy you can omit things, make errors and make your database accessible to people who shouldn't. So I never took the step and that's probably why I kind of stopped coding altogether. I didn't trust my capacities enough to build something safe. Whenever I needed to create a database of a kind, I stored the data in a file in text format. This is very far from efficient but I felt comfortable like that.
Databases are tricky
The other day I talked to a guy who was dealing with databases and he confirmed my fears. Not only are there security issues. There are maintenance issues as well. Simply the ever changing php and MySQL versions can make a well working database broken from one day to the next. Probably it's not different for other programming languages either. Then you need to manage the access rights. Who can watch what. Who can modify which tables... This makes the handling of databases not only time intensive but also cost intensive. Also there is the human risk factor with people who use too easy passwords, don't pay attention on which link they click...
Well I'm by far no specialist when it comes to that and there are probably many who know the situation better. But a couple of days ago, I had a lightbulb going on when reading a post by @amr008. He was actually using hive as a database to store business data from monitoring the temperature in server rooms. He simply stored the data in the form of JSON on Hive!
Hive is a cheap database that can be used by everybody
When looking at this example, I believe that Hive could be considered as a database for any kind of business. There are plenty of advantages:
- You don't need to host or pay for server space. You only need the necessary RC on your account for writing the data.
- The reading, writing rules are easy to set up. Simply define whether posting key or active key is necessary to add to the database. Use encryption if the content is not for everybody's eyes.
- Thanks to Hive keys, very secure login to the database.
- No need for special software to write to the database. Almost any programming language can produce and read json format.
- Every internet capable computer can access the database.
- If one server collapses there are many other servers (witness nodes) that still carry the data. It is therefore always accessible.
Using hive as a database could represent some speed issues because of the block time. Where most databases read and write in miliseconds, Hive needs longer.
Again, I'm only a hobby programmer and some stuff above is probably not 100% accurate. In my opinion however, Hive could play an amazing role as a decentralised database for any type of business. I believe we have by far not realized all the potential that resides in Hive....
Let's connect ! You can find me on these platforms:
Now this is an interesting idea ... Hive as essentially free database space for business... please excuse me tagging you, @hivelist and @hivehustlers and @hivewhat, but there are a number of small-to-middling-sized businesses who probably do not realize what Achim has pointed out, but who would be intrigued with the possibility, particularly at this moment when inflation is up and business expenses are tight... this could be an opportunity for Hive to make inroads among business owners ... "Hive fixes this"...
It's definitely another case where you could say "hive fixes this". I don't really know technically but it can be definitely achieved. When you look at how Splitnerlands uses custom JSON to save data related to the game on the blockchain, I believe such tools could be used by a big number of businesses. Thanks for stopping by!
It is a pity to use HIVE as a simple database as it is much more than that, but it's great that it can be used like that, too! It's amazing how many use cases it has that we aren't even aware of...
When you look at the whole blogging side of hive. The blockchain actually plays the role of database, storing all the post content into the blockchain. Not much different from what wordpress does with mysql.... Now we can imagine all the other things that could be sotred on hive...
Sometimes, the simple is the way to reach the masses ... how many small-to-middling-sized businesses need a database solution like this? Power up enough Hive for about $200 and have that taken care of for a WHILE? This is another "Hive fixes this" situation! If only we had a marketing team to research the viability of this...
I like your idea of encrypted entries in hive. I need to play with python some to learn to interfacing with hive.
!PIZZA
That was my plan as well. I think python is used a lot for that.
I saw someone talk about it before in this post. Custom JSONs are quite amazing.
Posted Using LeoFinance Beta
I don't really know what you can all put into custom jsons but I believe it's pretty limitless and you can easily protect it with encryption.
A great idea and there is potential there. Adrian is storing is Backlinks on chain.
In a way, if we had some base code to do it, we could all use hive to store data :-)
Probably some potential there.
Funny, I used access alot before and it can be ver useful.
That was my bible for a long time lol
I am also self learnt, wish I had kept up with database programming, it's very in demand.
If my own employer wants to change his database, I would probably need to read the whole book again lol. If you are not working with it regularly, it's difficult to keep up to date and not forget.
Yeah that's true with most things technical I guess. Perhaps I will learn again when the kids are a bit older.. lol
I've also bee thinking for months now on building something using also Hive as my database. I am more of a hobby programmer too and would love to thinker with this idea. I have already drafted my UX/UI for my website that would be powered by Hive. All I have to do know is to create content (my current weakness) for it. Hope to have a working prototype by the end of the year. 😊
The main reason that I decided to make use of Hive as my database is it's free and more secure. We don't have to be aware of the tricks or addons to make it more secure from possible hacks - it is a blockchain. 😍
For the same reason that I see the Hive is currently being undervalued if you think about the wonderful dApps that we can build on top of it.
!1UP
That's so true. There is so much potential here and it's hardly discovered yet I believe. Thanks a lot for the curation!
👍🏻 Think your idea is just what a lot of people use Hive for: a decentralized database for their Blog, Pictures or in my case Podcast episodes. Many are not aware but it is like that in the end.
Exactly. Instead of running a blog with wordpress and a mysql database, we simply use a front-end and store our text on the blockchain.
Hive as a database... Smh, I can't comprehend my mind with that because a database should be secure and just some people have the right to access the database 😅
Data leakage every day 🤣
!LOL
You are not wrong about this. There is however tons of data that doesn't need to be protected. Whenever you write a blog post, the content of your post is stored on the blockchain. It's data that you actually want the world to see and in this respect the blockchain plays the role of a database!
lolztoken.com
Close the door, I am dressing.
Credit: reddit
@achim03, I sent you an $LOLZ on behalf of @cursephantom
Delegate Hive Tokens to Farm $LOLZ and earn 110% Rewards. Learn more.
(2/2)
This is one good subjective view of the matter. I stopped coding about ten years ago when I became a manager and being more involved in planning and resourcing.
Well, yes, I can still set up some WordPress and change something, and I can also set up some database (MySQL) if necessary, but I can't do it anymore, precisely because of what you mentioned. You write you delete, you pull out, you adapt. You can do almost everything in this simple blog
In fact, you have everything you need right here. !BEER
I was using Joomla (starting with version 1.4) and then wordpress but each time there was a new version of either software or php version, my website became obsolete. Hive is so much less fuss... Be it in terms of blogging or also for database management, hive is a swiss knife that can do almost everything :-)
Yes, it's true, Joomla took a lot of time to edit, WordPress is easier... but here, when you see the live development (and you don't have to bother with it), it's much better.
I have interest in Both Coding and Database Side.. and pretty confused which side I should prefer more like as priority.
As of now looking forward to start with learning coding instead of wasting time and well from reading your experience now seems like coding should be first thing to do but I look forward to hear advice from you on this.
Haven't thought hive as a database aspect before and in Decentralized way it seems pretty Good.
My suggestion would be to go ahead with coding . Eventually you will need to learn a bit about databases anyway .
Posted Using LeoFinance Beta
When I started to learn coding, I wanted to create websites. That's why I started with html and css. Then came javascript and php, the more the needs evovled. It really depends on what you want to do. I made very good progress with a paid course by https://www.codecademy.com/. I can only recommend it. There are some free courses to get started.
As you said it evolved.. what I want is to learn Coding that will help me ahead in Blockchain space.
Thanks for recommending that one. Will check it out and yeah have searched for free courses will to stick to that in beginning.
View or trade
BEER.Hey @achim03, here is a little bit of
BEERfrom @seckorama for you. Enjoy it!Do you want to win SOME BEER together with your friends and draw the
BEERKING.You have received a 1UP from @thecuriousfool!
@leo-curator, @ctp-curator, @vyb-curator, @pob-curator, @cent-curator
And they will bring !PIZZA 🍕.
Learn more about our delegation service to earn daily rewards. Join the Cartel on Discord.
I gifted $PIZZA slices here:
@ijat(2/5) tipped @achim03 (x1)
curation-cartel tipped achim03 (x1)
Send $PIZZA tips in Discord via tip.cc!