...
- Variety of design tools for different needs
- Programmable Web concepts - integrate 3rd party open APIs
References
| Reference_description_with_linked_URLs_______________________ | Notes______________________________________________________________ |
|---|
|
|
|
|
| https://app.diagrams.net/#G1rbB6ZcNg8-8lLpT3vIH4Ir-t0DpPdYyM | draw.io free account |
| Libre Office drawings |
| Lucidchart subscriptions |
|
|
|
|
|
|
| https://cliquestudios.com/free-wireframing-tools/ | Wireframes - Best free wireframe tools in 2019 |
| https://careerfoundry.com/en/blog/ux-design/free-wireframing-tools/ | Wireframes - The 9 Best Free Wireframe Tools for UX Designers for 2021 |
| https://mockitt.wondershare.com/wireframe/wireframe-tools-open-source.html | try Wondershare or ? |
|
|
| should forward, reverse engineer from model to db scripts should have ERD, schemas for SQL, NoSQL |
| https://www.guru99.com/data-modeling-tools-design-database.html | very good list ** |
| https://dbeaver.io/ | DBeaver - Community Edition |
| https://www.gleek.io/blog/data-modeling-tools.html | free trials |
| https://www.visual-paradigm.com/shop/vp.jsp?license=perpetual | visual paradigm toolset - different versions - all priced |
| https://app.diagrams.net/ | draw.io diagram tool can use gdrive ** |
| https://wisdomplexus.com/blogs/open-source-data-modeling-tools/ | Good list of open source design tools ** |
| https://www.dbdesigner.net/plans/ | low monthly cost |
| https://www.oracle.com/in/database/technologies/appdev/datamodeler.html | Oracle SQL Developer for data modeling |
|
|
|
|
|
|
|
|
| should define model objects / metadata w logical views over entities should generate full db, ORMs, MVC, frontends |
| Grails |
https://www.jhipster.tech/ https://github.com/jhipster/generator-jhipster | JHipster |
| Feathers |
| https://www.findbestopensource.com/tagged/crud-generator | EOS CRUD generator list |
| https://github.com/jaxio/celerio-angular-quickstart | Java Angular CRUD generator from DB schema |
| https://awesomeopensource.com/projects/crud-generator |
|
|
|
|
|
|
|
| should support visualization, creation of shared data sets, transformations, parms generate data frame or workbook for user to run analytics, what ifs |
| BIRT |
https://www.predictiveanalyticstoday.com/open-source-free-business-
intelligence-solutions/ |
|
| https://logz.io/blog/business-intelligence-tools/ |
|
| https://www.ubuntupit.com/best-open-source-bi-tools-and-software/ |
|
|
|
| should define entity physical, logical models, messages ( request, response ) |
| https://openapi.tools/ | very good open tools list ** |
| https://github.com/Rhosys/openapi-explorer/blob/main/README.md | OpenAPI explorer reads messages, generators API doc ** |
| https://github.com/OpenAPITools/openapi-generator | OpenAPI Generator * |
| https://gum.co/openapi_generator_ebook | Beginners Guide to Code generation for openapi |
| https://redocly.github.io/redoc/#section/Authentication | Petstore app generated as an openapi specs w React Html - supports features |
| https://techbeacon.com/app-dev-testing/8-open-source-tools-will-lift-your-api-game | good list of some of the same tools in the openapi/tools list |
|
|
|
|
| define producers, consumers, transformers |
|
|
|
|
|
|
|
|
|
|
| define jepls with producers, consumers, objects, methods, data, events, handlers |
| https://www.archimatetool.com/ | TOGAF Archimate toolset ** |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| CMS tools |
|
| xwiki |
|
| jspwiki |
|
| liferay |
|
| drupal |
|
| wordpress |
|
|
|
|
|
| ERP open source |
|
| https://opensource.com/tools/enterprise-resource-planning |
|
https://dynamics.folio3.com/blog/open-source-enterprise-resource-planning-
software/#Odoo |
|
|
|
|
|
|
|
| https://www.programmableweb.com/category/all/apis |
|
|
|
|
|
|
|
|
|
| icons |
|
| https://www.flaticon.com/free-icons/library | free icon library ** subscribed |
|
|
| m Grails | Grails 4x - simple application modeling |
|
|
...
Potential Challenges
Candidate Solutions
Fed Data Downloads
https://www.federalreserve.gov/datadownload/Choose.aspx?rel=H10
Programmable Web API Directory
https://www.programmableweb.com/category/all/apis
Wikipedia API | The unofficial Wikipedia API. Because Wikipedia is built using MediaWiki, which in turn supports an API, Wikipedia does as well. This provides developers code-level access to the entire Wikipedia... |
| Amazon EC2 API | The Amazon Elastic Compute Cloud (Amazon EC2) API is a web service that enables you to launch and manage Linux/UNIX and Windows server instances in Amazon's data centers. Giving users the ability to... |
| Coinbase API | Coinbase is an electronic service and "wallet" for bitcoins and digital currency. Users can transfer currency, pay merchants, and make other payments instantly. The Coinbase API allows developers... |
| DIM API | DIM is a decentralized chat platform designed to be compatible with Bitcoin, Ethereum, and other blockchain account addresses. DIM features point-to-point encryption, high concurrency, low latency,... |
| Easy Blockchain API | Easily store entries within multiple blockchains. Hides the complexities of the underlying technologies, such as multiple complex calls, wallets, coins, etc. The Easy Blockchain API is blockchain.. |
| Blockchain Wallet API | The Blockchain Wallet API allows Merchants to use a simple interface can to interact with electronic wallets. This API decrypt the wallet as needed and re-saves. This API uses HTTP GET and POST... |
| Corda API | Corda is a blockchain platform for business. Application integrated with Corda can handle 600 transactions per second, support shared transaction histories, are 100% compatible with other blockchains... |
| Algorand API | The Algorand API provides blockchain services for financial operations. Algorand in REST architecture supports JavaScript, Python, Java, and Go programming languages to access the API. Algorand is... |
| Paxos API | The Paxos API allows users to build and integrate products with Paxos digital financial infrastructure. This API utilizes OAuth2 in its authorization flow, and enables third parties with permission... |
| Crowdz API | The Crowdz API retrieves business payments data, aiming to eliminate invoice use. Developers can authenticate with an API Key to make calls that will display JSON formats in return. Crowdz is a... |
| AirSwap Server API | AirSwap Server can be used to set and get intents locally, approve Tokens for trading, submit orders, and more blockchain-related functionalities. The API features REST architecture, and JSON... |
| TradeLens API | The TradeLens API returns supply chain data powered by blockchain technology. The API uses JSON format to return responses and uses Swagger URLs for sandbox and production goals. Developers can... |
| Basecamp API | From 37signals. Basecamp is a unique project collaboration tool. Projects don't fail from a lack of charts, graphs, or reports, they fail from a lack of communication and collaboration. Basecamp... |
| Slack Web API | Slack is a tool for managing team communications. Slack brings together all of a team's messages, files, and posts from Twitter, Dropbox, Trello, Google Docs, GitHub, and other services in one place... |
| QuickBase API | QuickBase is a low-code platform that unifies IT and Business to quickly... |
| Passfort API | Passfort offers automated Know Your Customer (KYC) and Anti-Money Laundering (AML) compliance services. The Passfort API provides programmatic access to the platform with methods to manage profiles... |
| GitHub API | GitHub is a repository of public open source and private business code. Is is a fast, efficient, distributed version control system ideal for the collaborative development of software. Use it to fork... |
| Amazon SimpleDB API | From their site: Amazon SimpleDB is a web service for running queries on structured data in real time. This service works in close conjunction with Amazon Simple Storage Service (Amazon S3) and... |
| Amazon RDS Relational Database Service API | Amazon Relational Database Service, aka Amazon RDS, is a web service that lets you set up, operate, and scale a relational database in the cloud. It provides cost-effective and resizable capacity |
| Factual v3 API | Factual is an open data platform for application developers that leverages large-scale data aggregation and community exchange. Our focus is on making data more accessible (i.e. cheaper, higher... |
| Food API | The Food and Recipe API is spoonacular's Food, Recipe, Menu, Restaurant and Nutrition API which allows users to access over 360,000 recipes and 80,000 food products. The API has a food ontology that... |
| Google BigQuery API | The Google BigQuery service allows users to run SQL-like queries against very large datasets, with potentially billions of rows. BigQuery works best for interactive analyses, typically using a small... |
| SQLify API | SQLify adds data conversion to any third-party application. The API converts JSON data into query-able data (CSV or SQL). SQLify offers full API access for free. A paid plan is also available which... |
| Google Cloud DNS API | Google offers access to a Domain Name System (DNS) management service utilizing Google's global infrastructure of name servers. The Google Cloud DNS API allows developers to store and look up IP... |
| Google Cloud SQL API | Google Cloud SQL provides a cloud-based MySQL database that is recommended for small- and medium-sized applications. It offers the same abilities and functions as MySQL along with some additional... |
| CKAN API | CKAN (Comprehensive Knowledge Archive Network) is an open-source data portal platform that provides an out of the box solution for managing, transferring, and accessing data. CKAN operates under a... |
| AnySQL Connector API | An API that lets you connect to any kind of SQL Database Management Systems. Currently Supports: MySQL SQL Server MariaDB CockroachDB IBM DB2 PostgreSQL. Before using the API, please make... |
| Amazon EC2 API | The Amazon Elastic Compute Cloud (Amazon EC2) API is a web service that enables you to launch and manage Linux/UNIX and Windows server instances in Amazon's data centers. Giving users the ability to... |
| Google+ Domains API | The Google+ Domains API enables Google Apps customers and ISVs with the ability to build custom Google+ functionality and services for people who use Google Apps at college, work, or home. Develop... |
| US Stocks Fundamentals API | The US Stocks Fundamentals API offers access to stock data based on the U.S. Securities and Exchange Commission. Over 12,000 companies are supported with over 8,000 indicators. Developers need to... |
| NASDAQ Data-On-Demand API | NASDAQ Data-On-Demand provides historical stock quote data. NASDAQ Data-On-Demand enables users to choose specific symbols and trading time periods for quick and efficient analysis. The data can be... |
| Finnworlds Analyst Ratings API | Analyst Ratings API includes current and historical buy, hold, sell ratings of analysts. As well as details about the analyst such as the firm, the success rate and return rate. It can also be used... |
| Sentiment Investor API | Sentiment Investor API enables developers to gather sentiment data about stock market from social media including Reddit, Twitter, Yahoo Finance and other sources. Data returned includes number of... |
| findl API | The findl API returns financial data including fundamentals for 15,000 US companies, prices data for 20,000+ US companies and funds, and investors data from 200,000+ insiders. From the provider: ".. |
Step-by-step guide for Example
...