r/programming • • May 08 '18

Excel adds JavaScript support

https://dev.office.com/blogs/azure-machine-learning-javascript-custom-functions-and-power-bi-custom-visuals-further-expand-developers-capabilities-with-excel
2.4k Upvotes

585 comments sorted by

View all comments

Show parent comments

5

u/therealcreamCHEESUS May 08 '18 edited Jan 08 '26

grandiose grab deserve sip quickest society upbeat tap chunky marble

This post was mass deleted and anonymized with Redact

2

u/yopla May 08 '18

Does it come with a form builder?

2

u/therealcreamCHEESUS May 08 '18

No but you have visual studio for building front ends.

Access is a database for non database people.

If you really need to be able to manipulate data either master excel or learn a proper DML like T-SQL.

With SQL you can have much larger database sizes, variables, more than 255 users, full joins, count distinct etc etc. So many features in SQL don't exist in access.

There is a very good reason why Access is not that well supported, its an inferior product for people who do not have the technical skills to properly manage data.

Sure its easier, cheaper and has a much shallower learning curve but if your doing anything important, you should do it properly or get a DB developer to do it properly. You will save yourself money and time in the long run.

1

u/yopla May 08 '18

I think you have a very narrow vision of the world. Maybe you never had a real job where you had to balance a budget.

In the real world you have millions of people making the best of their limited resources and building apps and process tools in excel and access.

First they do not have the skills to use sql server and visual studio.

Second they dont have the budget to buy them and/or hire someone.

Third, so many of those apps dont even require the complexity of the infrastructure you're suggesting.

Do you think it make sense to use SQL server for a tool used by a secretary to manage a total of 100 invoices per year? You can do a full text search on 10 years worth of invoices without even needing to index anything and it'll still be fast.

That same secretary will be much better off with a less than perfect access tool over nothing because she can't afford your perfect architecture.

Sometime the inferior product is the best tool for the job.

→ More replies (7)