database design – Web service specification – examples, methods, and tools

I hope my message will not be too irritating, but that it will be useful to someone in the future.

I've already made some progress myself (I'm talking about a raw and unfinished version of the technical paper) and I've done some research on the web – but any additional clue will be welcome.

Below I will give a sequential (but precise) abstract description.

What I have:

On my current job, I have a web service. He has:

  1. a user interface,
  2. some validations performed in filling forms within this interface (at the client level),
  3. list of variants of certain fields queried in an internal database using specific SQL conditions
  4. background logic for processing submitted forms
  5. basic logic / database to store information from the submitted information
  6. a frontal logic to recover information already submitted
  7. probably something else that I forgot to mention)))

What I need to do:

I have to compose a technical description (with text, tables and probably diagrams) of how the system works (both frontend and backend).

Why do I need it?

we (me, system analyst and my supervisor and developer team) are going to get this description. Then we will examine it and think about what we can and / or will change. Then I will make a technical drawing for the things we will change / add (if there will be any).

What problems did I encounter:

  1. I do not really find any example document of this type, which would be well designed and easy to understand.
  2. I was looking for online courses on this subject, but they all look very generic.
  3. The "1" and "2" points above refer to the technical description document that I have to create now and to the technical design document – in the future.

I hope for your help. And, as I say in the usual, the answer is appreciated, ignorance will be understood.

How to design a system that requests data from a limited API?

I have encountered a problem when designing a system. The system will request a set of data from its users to several APIs from different services. Each API has its own limit, for example 1 user per query, 100 users per query per minute or 1000 users per query every 10 minutes.

Until now, my only solution is to have a queue system. Grouping APIs according to the limit, for example those within 10 minutes, 1 minute and no limit. Suppose that there are 10,000 users. As a result, there will be 10 requests for each API with a limit of 1,000 users per request per 10 minutes and 10,000 requests for those that allow one user per request.

I just want to see if there is a way to optimize what I am doing now. I can predict that the data received will be delayed exponentially as the number of users increases. With 10,000 users, it will take 100 minutes to get a full cycle. But I guess that's what to expect anyway since the API has an imposed limit.

Design a database without knowing the structure

I am looking for some advice on designing a database when I am unsure of the data required. I use MySQL. To put a little context, I build a reporting system. So to start, I have a report table (I show my migration which is used in Laravel)

Schema::create('reports', function (Blueprint $table) {
    $table->increments('id');
    $table->unsignedInteger('user_id');
    $table->string('report_name');
    $table->string('status')->nullable();
    $table->timestamps();
    $table->softDeletes();

    $table
        ->foreign('user_id')
        ->references('id')
        ->on('users')
        ->onDelete('cascade');
});

So it's pretty simple, a report is linked to a user and it has a name and status for the report. Now, a report can be one of the three types of reports I offer. As such, I created a report_types table

Schema::create('report_type', function (Blueprint $table) {
    $table->increments('id');
    $table->unsignedInteger('report_id');
    $table->string('report_type');
    $table->timestamps();
    $table->softDeletes();

    $table
        ->foreign('report_id')
        ->references('id')
        ->on('reports')
        ->onDelete('cascade');
});

So, one type of report is linked to a report. It is there that I am a little confused. Once again, a bit of context. A user selects his report type and downloads data. This data is then sent to an external system and I receive a response that matches the data I want to capture. For the first report, the data is structured, I know what I'm getting back, so I can potentially do something like this because I know what data I'm getting

Schema::create('report_one_data', function (Blueprint $table) {
    $table->increments('id');
    $table->unsignedInteger('report_id');
    $table->string('inputOne');
    $table->string('inputTwo');
    $table->string('inputThree');
    $table->string('inputFour');
    $table->timestamps();
    $table->softDeletes();

    $table
        ->foreign('report_id')
        ->references('id')
        ->on('reports')
        ->onDelete('cascade');
});

First of all, I'm not sure this is the best approach, using a different chart for each type of report. My biggest problem is this. If they choose the two report, the answer I get from this external system includes the data from the file downloaded by the user. As such, I'm not sure of the columns I need.

What would be the best way to handle such a situation?

Thank you

Web Design – Dot5 Hosting for Custom HTML

First poster.

Anyone is familiar with Dot5 Hosting and whether he allows custom HTML? This seems like a pretty dated business, but my dad just paid a one year subscription and wants me to personalize his professional portfolio.

https://www.dot5hosting.com/

I could not find any useful video online to offer a tutorial.

mysql – Diagram Design of the Sales Database

I need to train the best database design, in terms of product movement

tickets

  • Adjustment of the stock (increase)

  • Opening of stock (product creation, initial stock)

  • purchases

departures

  • Inventory adjustment (decrease)
  • The sales

Disk design

**Movimiento**
 id
 movimiento
 idProducto
 cantidad_before
 cantidad_after
 cantidad
 ref_id_compra (cuando el movimiento sea una compra, guarda el el id de 
 del registro de la compra)
 ref_id_venta(cuando el movimiento sea una venta, guarda el el id de del 
 registro de la venta)
 id_tipo_movimiento


**Tipo_Movimiento**
 id
 movimiento

enter the description of the image here

Is it feasible? The design is at my discretion, may include poor design practices, but up to now, that is what I could design according to the needs, I would like to avoid future problems that affect the flow and scalability of my system.

Question
How could I rethink or improve this design based on the initial requirements? I will be attentive to any suggestion, thank you

Websites / Design and Development Service for Web and Mobile Applications – Consultation and FREE quote first!

We understand that every project, small or complex, requires a unique, intelligent and creative approach. Our digital experts, software engineers and development architects are ready to take on any challenge in order to provide you with the most efficient, structured and secure solutions that meet the needs of your business.

We serve as a consulting team in development and project. Our development team is ready to ensure that your project is executed correctly, from the initial consultation phase, properly planned, executed and, of course, delivered on time. We provide a true full-cycle development service. Beginning with first advice, planning, integration, quality assurance and delivery. Each project comes with a contractual commitment to maintain and support the delivered project.

If you have an advanced CRM to develop, an API to integrate or build, an open source project modification / development, a complete e-commerce or a professional website design and coding or a simple project such as PSD to CMS / HTML or HTML / WIX to code on a CMS platform such as Drupal or WordPress, projects of any size, are welcome.

CONSULTATION

During this phase, our team of experts will review the requirements of your project to identify existing challenges and take advantage of opportunities.

EXPERIENCE

Our team has significant experience in the vast majority of the latest web development and software development technologies and has a successful track record with over 25 years of combined experience.

CRAFTS
Our team members have project management experience in several vertical IT industries. We offer an AZ development cycle followed by consultation, planning, analysis, design, coding, integration, testing and fast and economical delivery.

PLANNING
It is essential to understand the objectives, critical points and deadlines of each project before starting the implementation phase. All projects require critical thinking and a detailed strategic plan, deliberately created by passionate people who understand exactly what you want to achieve.

STRONG TEAM

Behind every big project, there is a good man standing behind. In addition to our in-depth knowledge and over 25 years of experience, we have access to extremely talented enthusiasts who are eager to join your next project.

DEVELOPMENT OF THE WHITE LABEL

Whether you are an independent or a business, you need additional developers to deal with current or future projects.

WALLET
We can not show everything because most of the projects we develop are subject to a strict NDA and yet we can share some projects for you:

  1. https://emmycook.com/
  2. https://evolvefitness.co.uk/
  3. https://davehakkens.nl/
  4. https://www.pokebowl.nl/
  5. https://codecanyon.net/user/codieslab/portfolio (some of our developed software is offered via CodeCanyon)
  6. http://marvelproducts.in/

    (More portfolio projects available and can be presented during our call / conference)

STRONGEST COMPETENCE

Among the strongest skills are OOPs (Object-oriented programming) and among the latest projects, we had a great opportunity to work with content management systems (WordPress, Magento, Drupal), PHP Core, Jquery, Laravel, Codeigniter, PHP Cake, Yii and Symfony, and I can say in all honesty that I have great strength with those.

COMMUNICATION

Transparency and communication are among our main benefits, whether it's a small, medium or large project. We are here and we are fully committed to providing you with daily updates and detailed workflow, ensuring a surprisingly crisp and clean code, a well-documented process flow of all modules under development, so that you can easily follow our work or anything new. developer can easily understand the system and join the project on the fly.

FREE CONSULTATION
If you have a project in mind but you do not know how to do it, we are ready to consult you for free, to provide you with a detailed estimate and to set a detailed timetable for you to decide and decide with clarity and easy if you have to go further. with us on this project.

CLOUD SPECIALIST

Among the members of our team, we have those who have a very good experience of Cloud and SaaS solutions. If you have a project to develop with Cloud, do not worry, we have specialists who can ensure that it is correctly executed.

We are ready for the next challenge, whether it's an advanced mobile app, a CRM platform, enterprise software development, a simple or advanced website. – We have the knowledge, the experience and can assure your satisfaction of the results we will provide. you with.

Send us an email to:
crm@codieslab.tech

We are here to help you today!



Get 10 great editable Facebook fan page cover banners for $ 2

Get 10 beautiful editable and editable Facebook fan page banners

Everyone knows that first impressions are everything. Facebook Fanpage cover images give that first impression to your Facebook traffic, so make the most of it. Get 10 great professional-quality fanpage cover pages for you that will welcome your visitors in the best possible way.

Normally, designers charge $ 5 to $ 15 minimum everywhere to get your facebook fanpage cover designed, I will give you 10 great facebook fan page covers for only $ 2 with the psd source file. Photoshop knowledge and even if you do not have to have a Photoshop software or expensive subscription in the cloud, just download the source file psd on the free site that I will reveal and modify.

.

Sell ​​- Design Now, Pay Later

To integrate

HTML:

BBCode:

Link of the image:

design patterns – Locked content before clicking on CTA

"Learn More" CTAs are used on article sites / news sites to determine if users simply open the article or they are sufficiently engaged to continue reading the rest.

In the example above, the given OTC may not be the best option. If they're looking for the graph and already have access to it, it only slows down the way they get their data, while "teasing" them that they are there.

An alternative to getting the clicks you might need is rather a button that says "Open Graphics", the graphic then appears on the same page. So, it's as if the user was loading in the graph after visiting the page.
Another solution would simply be to display the graph on a separate page and then follow the page visits.

If the user does not have access to the graphics and you are trying to upgrade and buy them, replace "Unlock Graphics" with "Upgrade to Unlock Graphics" may be more descriptive and allow the user to know what they are. clicking on.

Whether or not a dark pattern depends on how it is implemented in this case. If they have access to them, but you hide them from them, it does not help the user and does not hide their access to your product. By using my suggestions in these cases, it may seem less obvious to hide things for no reason, but rather to ask for an extra click / page to load the information intended for the user.
If they do not have access to the chart, rephrase the unlock button to be clearer on where they will be taken or what it will do to help. In addition, the graph behind the overlay should not be the actual chart (as they might just look through), and could simply be a false graph blur to induce them to see what might be there.