Earlier this year, in February (2018), HarperDB organized a Hackathon and thanks to that I found a database I had been looking for. By mixing the NoSQL with SQL, I now have a database that will let me scale easily, while still being able to use SQL (I love SQL for some reason).
You see, in my High School time, I had MySQL in our Java classes and the whole concept of Databases seemed amazing at that time and then operating with SQL queries seemed even more amazing and over the time, I’ve fallen in love with it. It is simple, fast and does a lot of things if you know your queries. Plus there’s Foreign Key concept, which I use in almost each and every project I work on. And the community is really great. So, if you’re stuck somewhere, you have a lot of people to ask for help.
However, you need to know your data type before building database. If you want to change a data type of a column and it is being referenced somewhere, it is not easy to change it. In past few years, a trend has increased for NoSQL databases, which is easily scalable, lightweight, fast and you don’t really have to define your data type. NoSQL is flexible and that’s the reason why a lot of companies are also moving to NoSQL completely or have incorporated NoSQL in some format in their architecture.
I personally would love to work on a NoSQL database, however, all my current project requirements needs me to stick to SQL, plus I feel like I work faster with SQL now. Plus, there’s one more issue why I haven’t incorporated NoSQL in any of my work, and the reason is that I cannot perform SQL queries on it. I need to parse the JSON and work with it and I’m not really a big fan of this.
HarperDB comes to the rescue. It works like a NoSQL database, but it lets us perform SQL queries on the database. So, I can scale easily via the NoSQL properties and still be able to use SQL queries and concepts. And what’s amazing is that HarperDB is really lightweight. I ran it on an AWS server and the read/write data was relatively lower. HarperDB’s twitter bio sums it up nicely
HarperDB radically simplifies #bigdata architectures providing a single model, schema-less #database with interfaces for both #SQL and #NoSQL
HarperDB is currently available only for Mac and Linux only. So, no windows. However, if you’re on windows 10, you can follow this guide to run Ubuntu on your your windows 10 and hence, execute HarperDB. As a security practice, you need to run HarperDB as a user and not as root. If you do try to run it as a root, you’ll be prompted with the error.
As soon as you configure it and run it, you’ll be greeted with a doggo and the success message.
If you want to know about HarperDB in detail, I’ll advice you to read this blog first, so as to know why you should use HarperDB. This blog is just a gist of what HarperDB can do. Read their blogs to know more in detail.
But, you know what? documentations suck, or so I believe. I personally love to see the working applications or examples of the technology before using it. So, you could check their examples section and there are the projects that won the HarperDB’s first ever Hackathon.
P.S : I stood third 😉
Hey there! I know this is kinda off topic but I was wondering if you knew where I could get a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having trouble finding one? Thanks a lot!
Hey, you can search for the “Google reCAPTCHA” WordPress plugin. It’s pretty much self-explanatory. But, if you run into issues, there are tons of blogs/videos where they explain how to set it up.
I simply wanted to type a quick word in order to thank you for those remarkable techniques you are placing here. My time consuming internet look up has at the end of the day been compensated with wonderful facts to exchange with my best friends. I would assert that most of us visitors are quite blessed to live in a useful community with very many special individuals with insightful strategies. I feel extremely happy to have seen your entire site and look forward to some more fabulous minutes reading here. Thank you once more for all the details.
Sweet blog! I found it while browsing on Yahoo News. Do you have any tips on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Thank you
Search engine indexing. I don’t recall doing anything special to get this shown up there.
Thank you a lot for giving everyone a very spectacular chance to read critical reviews from this web site. It is usually very useful and also packed with fun for me and my office peers to visit your website at least thrice weekly to find out the new guides you have got. Of course, I’m also certainly fulfilled with all the splendid thoughts you serve. Selected two points on this page are in truth the most efficient we have had.
I do like the manner in which you have framed this specific challenge plus it does indeed give me personally a lot of fodder for thought. On the other hand, from just what I have seen, I just simply trust when other feed-back pile on that people stay on point and in no way get started upon a tirade of the news du jour. Yet, thank you for this excellent point and though I can not really concur with it in totality, I regard the standpoint.
I know this if off topic but I’m looking into starting my own blog and was wondering what all is needed to get set up? I’m assuming having a blog like yours would cost a pretty penny? I’m not very web smart so I’m not 100 sure. Any recommendations or advice would be greatly appreciated. Thanks
This one’s “WordPress”. It’s free and you can host it on your own server if you want, or it’s available to be hosted on most of the providers.
Hey There. I discovered your blog using msn. This is a really well written article. I抣l be sure to bookmark it and return to learn extra of your useful information. Thanks for the post. I抣l definitely return.
Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You obviously know what youre talking about, why waste your intelligence on just posting videos to your weblog when you could be giving us something informative to read?
My brother recommended I might like this website. He used to be totally right. This post actually made my day. You cann’t consider simply how much time I had spent for this information! Thanks!
I’m really enjoying the design and layout of your website. It’s a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out a developer to create your theme? Outstanding work!
Normally I do not read article on blogs, however I would like to say that this write-up very pressured me to take a look at and do so! Your writing style has been amazed me. Thank you, quite great article.
My brother suggested I would possibly like this website. He used to be entirely right. This publish actually made my day. You can not imagine simply how so much time I had spent for this information! Thank you!
It抯 actually a nice and helpful piece of information. I am glad that you shared this helpful info with us. Please keep us informed like this. Thanks for sharing.
Thanks for every other informative web site. Where else may I am getting that kind of information written in such an ideal method? I’ve a challenge that I am simply now operating on, and I have been at the look out for such information.
I like what you guys are up also. Such clever work and reporting! Keep up the superb works guys I’ve incorporated you guys to my blogroll. I think it will improve the value of my website :).
Usually I do not learn article on blogs, but I wish to say that this write-up very compelled me to take a look at and do it! Your writing taste has been surprised me. Thanks, quite nice post.
Very nice post. I simply stumbled upon your blog and wished to say that I have really loved surfing around your blog posts. After all I’ll be subscribing on your feed and I hope you write again very soon!
Excellent read, I just passed this onto a colleague who was doing a little research on that. And he actually bought me lunch since I found it for him smile Thus let me rephrase that: Thanks for lunch! “Life is a continual upgrade.” by J. Mark Wallace.