Tech Lead/Team Lead. Senior WebDev.
Intermediate Grade on Computer Systems-
High Grade on Web Application Development-
MBA (+Marketing+HHRR).
Studied a bit of law, economics and design
Location
Spain
Education
Higher Level Education Certificate on Web Application Development
It's necessary to learn database types and try at least one of each.
Back those days I learned MySQL and SQL Server, on an era where you could connect a Microsoft Access DB to a web monolith to sync local changes with remote changes because it was a trend and an easy way to go to deal local software (DB Forms and views) plus online tools such e-commerce and so.
Nowadays that workaround is forbidden for obvious reasons and you need to know at least a relational database such MySQL/MariaDB and maybe some about mongo and Postgre, knowing a bit that three options while deep learning one of them lets you work with any of the existing on the market.
Neither it's necessary to be those three exactly, you can pick up another one of each type of course.
BTW and answering the title you need to know about databases for many reasons, one of them being the need of having one on the 99,99% of the projects and the second one being the knowing about data storage and implications it has when developing software. When you learn about your language and the database it's used on your project you can code things efficiently.
Also the major part of us are full stack but specialized on either back or front end (I think there are no senior devs uncapable to code a web app using back and front + DB + server config combined) so sometimes you'll need to throw a query directly into production DB to fix something, or perform queries to get data or aggregated data to get some BI related stuff at business level on a manner or another.
I'm supposed to be in front end but I solve database related tasks almost every day and I put my hands on back end development several times a year, and it's like this since I started coding professionally so I would say it's a must
Thanks for sharing Joel, this is very insightful. I like your point about knowing just a couple of the database options out there, while having a deeper understanding of at least one, will set you up to work with any of the existing DB's on the market. If you ever end up checking out HarperDB, we'd love to hear your thoughts! :)
Tech Lead/Team Lead. Senior WebDev.
Intermediate Grade on Computer Systems-
High Grade on Web Application Development-
MBA (+Marketing+HHRR).
Studied a bit of law, economics and design
Location
Spain
Education
Higher Level Education Certificate on Web Application Development
Tech Lead/Team Lead. Senior WebDev.
Intermediate Grade on Computer Systems-
High Grade on Web Application Development-
MBA (+Marketing+HHRR).
Studied a bit of law, economics and design
Location
Spain
Education
Higher Level Education Certificate on Web Application Development
Yes we have a REST API so we are language agnostic, and we have traditional drivers and interfaces. We have example code in the Management Studio available in most languages.
Tech Lead/Team Lead. Senior WebDev.
Intermediate Grade on Computer Systems-
High Grade on Web Application Development-
MBA (+Marketing+HHRR).
Studied a bit of law, economics and design
Location
Spain
Education
Higher Level Education Certificate on Web Application Development
Nice I'll take a look :)
I saw pricing depending on RAM, does CPU also scale proportionally? Can you set up auto-scale to avoid service saturation when some campaign is set up or do you have to control it manually?
Also if I need 32 or 64Gb for 2 days or a week do you charge me with monthly cost of 64 Gb even when usually running ok with 8Gb?
HarperDB Cloud managed instances run on provisioned Amazon EC2 instances. The CPUs scale proportionally as well, you can read more about the instance hardware specs here. HarperDB Cloud does not currently offer autoscaling, but you can manually scale instances. Because instances are single tenant, you always have reserved capacity and will be billed for the monthly cost of your instance.
Tech Lead/Team Lead. Senior WebDev.
Intermediate Grade on Computer Systems-
High Grade on Web Application Development-
MBA (+Marketing+HHRR).
Studied a bit of law, economics and design
Location
Spain
Education
Higher Level Education Certificate on Web Application Development
So what is the benefit against GCP or AWS?
I understood the API thing but nothing that can't be provided easily by my own (speaking from the business point of view)
I'm not sure I fully understand your question here, maybe that you don't need an SDK? If you'd like, it might be easier if we start a direct chat here on Dev so we can have quicker back and forth. Or feel free to shoot me an email margo@harperdb.io
Tech Lead/Team Lead. Senior WebDev.
Intermediate Grade on Computer Systems-
High Grade on Web Application Development-
MBA (+Marketing+HHRR).
Studied a bit of law, economics and design
Location
Spain
Education
Higher Level Education Certificate on Web Application Development
well the purpose of keeping it as thread is to answer possible questions others could have too.
I mean that If I set up an API let's say using PHP + MySQL I can use Laravel and benefit from the ORM plus isolating on that instance the microservice/service related code and DB.
I can set it up on an Amazon EC2 which will be cheaper than relegating the DB stuff to harperDB, isn't it?
Also the ORMs usually don't work through REST calls but connecting itself into a DB instance.
I'm trying to balance costs of development with costs of architecture comparing that to what it could be using it. Also I'm trying to understand what can HarperDB offers me that I can't get with Google Cloud Platform or Amazon Web Services "as is" or at low cost (few hours of a programmer)
An ORM is not necessary with HarperDB, as the primary method of interaction is through the API. This does not add any overhead to the application, in fact, it removes a layer from your application stack because HarperDB natively returns JSON objects.
Additionally, HarperDB can be installed wherever you'd like. We offer a DBaaS product, HarperDB Cloud, but you can also find HarperDB on npm.
Tech Lead/Team Lead. Senior WebDev.
Intermediate Grade on Computer Systems-
High Grade on Web Application Development-
MBA (+Marketing+HHRR).
Studied a bit of law, economics and design
Location
Spain
Education
Higher Level Education Certificate on Web Application Development
I think you've not internalized what an ORM is but anyway I'll take a look for another stuff i've in mind it can work well with some controller or gateway or without that depending on the possibilities of Harper :D
It's necessary to learn database types and try at least one of each.
Back those days I learned MySQL and SQL Server, on an era where you could connect a Microsoft Access DB to a web monolith to sync local changes with remote changes because it was a trend and an easy way to go to deal local software (DB Forms and views) plus online tools such e-commerce and so.
Nowadays that workaround is forbidden for obvious reasons and you need to know at least a relational database such MySQL/MariaDB and maybe some about mongo and Postgre, knowing a bit that three options while deep learning one of them lets you work with any of the existing on the market.
Neither it's necessary to be those three exactly, you can pick up another one of each type of course.
BTW and answering the title you need to know about databases for many reasons, one of them being the need of having one on the 99,99% of the projects and the second one being the knowing about data storage and implications it has when developing software. When you learn about your language and the database it's used on your project you can code things efficiently.
Also the major part of us are full stack but specialized on either back or front end (I think there are no senior devs uncapable to code a web app using back and front + DB + server config combined) so sometimes you'll need to throw a query directly into production DB to fix something, or perform queries to get data or aggregated data to get some BI related stuff at business level on a manner or another.
I'm supposed to be in front end but I solve database related tasks almost every day and I put my hands on back end development several times a year, and it's like this since I started coding professionally so I would say it's a must
Thanks for sharing Joel, this is very insightful. I like your point about knowing just a couple of the database options out there, while having a deeper understanding of at least one, will set you up to work with any of the existing DB's on the market. If you ever end up checking out HarperDB, we'd love to hear your thoughts! :)
Is it something new? Didn't heard about it till now
HarperDB has been around since 2017, and we released HarperDB Cloud (our DBaaS) about 6 months ago.
Oh I understand. Do you have driver and API for any language or it works as a service only?
Yes we have a REST API so we are language agnostic, and we have traditional drivers and interfaces. We have example code in the Management Studio available in most languages.
Nice I'll take a look :)
I saw pricing depending on RAM, does CPU also scale proportionally? Can you set up auto-scale to avoid service saturation when some campaign is set up or do you have to control it manually?
Also if I need 32 or 64Gb for 2 days or a week do you charge me with monthly cost of 64 Gb even when usually running ok with 8Gb?
HarperDB Cloud managed instances run on provisioned Amazon EC2 instances. The CPUs scale proportionally as well, you can read more about the instance hardware specs here. HarperDB Cloud does not currently offer autoscaling, but you can manually scale instances. Because instances are single tenant, you always have reserved capacity and will be billed for the monthly cost of your instance.
So what is the benefit against GCP or AWS?
I understood the API thing but nothing that can't be provided easily by my own (speaking from the business point of view)
I'm not sure I fully understand your question here, maybe that you don't need an SDK? If you'd like, it might be easier if we start a direct chat here on Dev so we can have quicker back and forth. Or feel free to shoot me an email margo@harperdb.io
Thanks Joel!
well the purpose of keeping it as thread is to answer possible questions others could have too.
I mean that If I set up an API let's say using PHP + MySQL I can use Laravel and benefit from the ORM plus isolating on that instance the microservice/service related code and DB.
I can set it up on an Amazon EC2 which will be cheaper than relegating the DB stuff to harperDB, isn't it?
Also the ORMs usually don't work through REST calls but connecting itself into a DB instance.
I'm trying to balance costs of development with costs of architecture comparing that to what it could be using it. Also I'm trying to understand what can HarperDB offers me that I can't get with Google Cloud Platform or Amazon Web Services "as is" or at low cost (few hours of a programmer)
An ORM is not necessary with HarperDB, as the primary method of interaction is through the API. This does not add any overhead to the application, in fact, it removes a layer from your application stack because HarperDB natively returns JSON objects.
Additionally, HarperDB can be installed wherever you'd like. We offer a DBaaS product, HarperDB Cloud, but you can also find HarperDB on npm.
I think you've not internalized what an ORM is but anyway I'll take a look for another stuff i've in mind it can work well with some controller or gateway or without that depending on the possibilities of Harper :D
Thanks for answering
Sounds good Joel, please let me know if any additional questions come up or you can always connect with our team on the Community Slack! :)