Considering FileMaker or Access for a Starter Database
-
@scottalanmiller said:
@PSX_Defector said:
SQL Server runs on any version of Windows. I use Developer on Windows 8. I've used Standard on XP. It's not a perfect solution, but if you need to get some info into standard format of SQL and don't have interwebs access, it's great.
The OP has an office too big to be used that way though for licensing reasons.
Just pointing out that Windows Server is not a requirement for SQL Server.
There is always the use of Azure's hosted DB. Again, simple, easy, ODBC compliant, uses standard SQL Server tools to modify and access. It's got some quirks, like I couldn't use hMailServer on it without some major modification of the schema, but otherwise it's plenty easy for quick and easy DB deployment.
Given the "need" for iOS "access", seems stupid not to put it in a hosted solution. Licenses are then just a line item on the invoice.
-
What is the pricing structure for MongoDB?
-
@BRRABill said:
What is the pricing structure for MongoDB?
There is a starter package for free. Then you can upgrade to the enterprise package for free. Then if you need HA clustering or global redundancy, that's an extra free.
Did I mention, it's free?
-
@scottalanmiller said:
@BRRABill said:
What is the pricing structure for MongoDB?
There is a starter package for free. Then you can upgrade to the enterprise package for free. Then if you need HA clustering or global redundancy, that's an extra free.
Did I mention, it's free?
I was a little confused by the wording on their website.
I thought it was free, but it was worded strange.
Like you can download it for free for evaluation and development.
That's like saying you can take the car for a free test drive and cross country trip.
-
@BRRABill said:
@scottalanmiller said:
@BRRABill said:
What is the pricing structure for MongoDB?
There is a starter package for free. Then you can upgrade to the enterprise package for free. Then if you need HA clustering or global redundancy, that's an extra free.
Did I mention, it's free?
I was a little confused by the wording on their website.
I thought it was free, but it was worded strange.
Like you can download it for free for evaluation and development.
That's like saying you can take the car for a free test drive and cross country trip.
Cloud Manager is not free, but you can get a trial for eval and development, maybe that is what you saw?
-
This is the important bit that tells you that it is truly free and protected free:
"MongoDB is covered under the GNU AGPL v3.0 license."
-
@scottalanmiller said:
Cloud Manager is not free, but you can get a trial for eval and development, maybe that is what you saw?
This is the page I was looking at:
https://www.mongodb.com/lp/download/mongodb-enterprise -
@BRRABill said:
@scottalanmiller said:
Cloud Manager is not free, but you can get a trial for eval and development, maybe that is what you saw?
This is the page I was looking at:
https://www.mongodb.com/lp/download/mongodb-enterpriseThat's not even the right website for MongoDB!! They are a .org.
-
-
@scottalanmiller said:
That's not even the right website for MongoDB!! They are a .org.
As BRRABill quickly tries to delete posts...
-
Are you sure they aren't related?
I will admit to not looking closely, but they look related.
-
@BRRABill said:
Are you sure they aren't related?
I will admit to not looking closely, but they look related.
They are related, same company, but one is the site for the database, the other is the site for the commercial services and add ons for the database. So looking at commercial support contracts and non-open software licenses will be very misleading compared to only looking at the free and open database product itself.
-
Many major OSes include MongoDB as well. MongoDB is provided with products like CentOS, RHEL and Ubuntu.
-
-
@BRRABill said:
Are you sure they aren't related?
I will admit to not looking closely, but they look related.
It's pretty common for Opensource firms to make their money off offering enterprise support agreements.
-
I have supported FM server here for the past 5.5 years (Versions 10-13, so far). It is OK from a small-scale perspective but like you said above, you don't want to look small-scale, especially since you will almost surely trap yourself. As far as I can tell, FM does not scale well. Our FM guy is a co-owner and taught himself how to create and maintain FM databases and he is pretty good at it. However, I am sure there are things he has done that were taking the long way around with a sort of house of cards effect. I would say that over half of our business relies on the 25 or so databases he has created.
We also use an ERP program, Southware (which seems horribly antiquated) for things like inventory, AR and AP. The only thing I do for that is deploy the thin-client software and maintain the windows server that it runs on, as we have a consultant company that specializes in it. We have tried to move off it several times but since we have customized it so much, we are pretty much stuck with it.
-
@wrx7m said:
I have supported FM server here for the past 5.5 years (Versions 10-13, so far). It is OK from a small-scale perspective but like you said above, you don't want to look small-scale, especially since you will almost surely trap yourself. As far as I can tell, FM does not scale well. Our FM guy is a co-owner and taught himself how to create and maintain FM databases and he is pretty good at it. However, I am sure there are things he has done that were taking the long way around with a sort of house of cards effect. I would say that over half of our business relies on the 25 or so databases he has created.
I supported FM for a company, NTG's second MSP customer, actually, for over a decade and it does its job well enough for what it is. But there is no doubt that it's extremely limiting in every possible way. They use it for a three person office that was two people in 2001 when the company started and grew to whopping.... two people over a decade later. During the summers they go up to three people for a few months during their busy season. For a company with zero growth and no high reliability demands (it can be down for a month at times without an issue) it worked fine. But, very limiting and they have had to pay a bit for it over the years and I'm not sure that a spreadsheet would not have been cheaper and easier.