Options for people who aren't programmers or DBAs (or who are and don't
want to go though a bunch of effort) to interact with the various forms
of organized data they may encounter are limited. It's especially bad if
a power user wants to create something for other people to interact
with. Most of us have encountered companies large and small keeping far
too much data in Excel spreadsheets. Access is not much better. On the
surface, it allows non-programmers to make applications, and programmers
to make more complex applications. In reality, it's too difficult for
non-programmers to do anything non-trivial and annoyingly restrictive
for programmers.
The world needs something better, and I have an unrefined concept of its
form. What I have in mind would integrate a (not yet developed) visual
programming language. Users could create fairly sophisticated apps by
dragging, dropping and plugging things together. Apps could be web-based
or desktop-based, and optimally would have the option of storing data
internally so as to preserve a document-based model for the user. Of
course, more advanced apps would have the option of using external data
files or connecting to a server. Programmers wishing to make more
sophisticated apps would have at least one real programming language
with a DSL or DSL-like library for interacting with the system. I'm
inclined to use the JVM and make several languages available. I'm
thinking of Tokyo Cabinet's table data store as the backend.
Two target markets come to mind: small businesses, and corporate
departmental-level power-users who don't want to involve IT.
Small businesses were the first market that came to mind for me. It
seems like these businesses are often buying software that's a poor fit
to their needs to manage their data. I see two likely use cases for this
sort of product. One is computer-savvy business owners making their own
applications. I suspect the bigger one is an app-store allowing easy
distribution of programs to work with data. Likely examples would be
point of sale and accounting software. In this model, the software
itself might even be free, with a retail box version coming bundled with
several popular apps.
The corporate market was suggested by a user on #startups who thought
selling to small businesses would be less than fun. I honestly don't
know a lot about the corporate world and I'm not sure about trying to
make a product for that market. I'm sure the market exists, but I'm not
sure what features would allow a startup to compete with the entrenched
Microsoft products already in use. Being able to talk to all the data
sources likely to be encountered in that environment more easily than
Access would likely be a good start. Does anyone who understands the
needs of the corporate market have some input?
The more I think about this idea, the more I like it. Am I crazy? Does
this have merit? Would you work on this? Would you invest in it? Would
you buy it?