Serverless Architecture – Integrating with Data Layer

My question is in context with the Serverless Architecture (e.g. AWS Lambda) and how does one interact with the Databases in this system.

Typically in a 3 Tier architecture, we have a web service which interacts with the Database. The idea here is to ensure that one database table is owned by one component. So changes in there, does not require changes in multiple places and there is also a clear sense of ownership so scaling and security are easier to manage.

However, moving to serverless architecture, this ownership is no more clear and exposing a web service to access a database and having a Lambda use this web service does not make sense to me.

I would like to know a bit on the common patterns and practices around this.

Integrating Django Rest Framework and Scrapy

Both Scrapy and Django Frameworks are standalone best framework of Python to build crawler and web applications with less code, Though still whenever You want to create a spider you always have to generate new code file and have to write same piece of code(though with some variation.) I was trying to integrate both. But stuck at a place where i need to send the status 200_OK that spider run successfully, and at the same time spider keep running and when it finish off it save data to database.

Though i know the API are already available with scrapyd. But i Wanted to make it more versatile. That lets you create crawler without writing multiple file. I thought The Crawlrunner https://docs.scrapy.org/en/latest/topics/practices.html would help in this,therefor try this thing also t Easiest way to run scrapy crawler so it doesn't block the script but it give me error that the builtins.ValueError: signal only works in main thread

Even though I get the response back from the Rest Framework. But Crawler failed to run due to this error does that mean i need to switch to main thread? I am doing this with a simple piece of code

spider = GeneralSpider(pk) runner = CrawlerRunner() d = runner.crawl(GeneralSpider, pk) d.addBoth(lambda _: reactor.stop()) reactor.run() 

Integrating Web Chat using React getting 403 Authorization error

Hi Below is the code I have adapted from https://github.com/microsoft/BotFramework-WebChat/tree/master/samples/03.a.host-with-react

<!DOCTYPE html> <html lang="en-US">   <head>     <title>Web Chat: Integrate with React</title>     <meta name="viewport" content="width=device-width, initial-scale=1.0">     <!--       For simplicity and code clarity, we are using Babel and React from unpkg.com.     -->     <script src="https://unpkg.com/babel-standalone@6/babel.min.js"></script>     <script src="https://unpkg.com/react@16.5.0/umd/react.development.js"></script>     <script src="https://unpkg.com/react-dom@16.5.0/umd/react-dom.development.js"></script>     <!--       For demonstration purposes, we are using the development branch of Web Chat at "/master/webchat.js".       When you are using Web Chat for production, you should use the latest stable release at "/latest/webchat.js",       or lock down on a specific version with the following format: "/4.1.0/webchat.js".     -->     <script src="https://cdn.botframework.com/botframework-webchat/master/webchat.js"></script>     <style>       html, body { height: 100% }       body { margin: 0 }        #webchat {         height: 100%;         width: 100%;       }     </style>   </head>   <body>     <div id="webchat" role="main"></div>     <script type="text/babel">         (async function () {         // In this demo, we are using Direct Line token from MockBot.         // To talk to your bot, you should use the token exchanged using your Direct Line secret.         // You should never put the Direct Line secret in the browser or client app.          const headers = {"Authorization", "Bearer <'secret key'>"}         const res = await fetch('https://directline.botframework.com/v3/directline/tokens/generate', { method: 'POST' }, {Headers:headers} );          const { token } = await res.json();         const { ReactWebChat } = window.WebChat;          window.ReactDOM.render(         <ReactWebChat directLine={ window.WebChat.createDirectLine({ token }) } />,         document.getElementById('webchat')         );          document.querySelector('#webchat > *').focus();         })().catch(err => console.error(err));     </script>   </body> </html> 

Below is the Error I am getting enter image description here

Integrating Azure custom BOT on SharePoint home page

I am planning to create a custom UI Bot using ReactJS and have it on the Home page(NOT modern) of our SharePoint site. After some research, i found out we can use it with SPFX webpart and possibly creating it using Visual Studio nodejs react app. The functionality of the bot should be something similar to the verizon bot shown in the images. When you click on the button the bot pops up.

My question is which is the better approach or feasible approach out of the two to achieve something similar in the images.

enter image description here

enter image description here

Integrating with a third-party SQL Server running locally

I have a little side-project where I’m faced with the task of integrating a cloud solution in azure with a database running locally on site. The database in question runs SQL Server 2008 and collects data in real-time from several cash desks on the site. The machine running the server has internet access but the network is not configured for accessing the server from the internet. I have complete access to the database locally (at least with SSMS).

What is the best way to sync the local data to the cloud? Mirroring? Some other way? Azure Data Sync? Since I’m designing a close to real-time system changes in the local database needs to be reflected as fast as possible.

I’m kind of a newbie when it comes to database management so any nudge in the right direction is much appreciated.

Integrating Area of a Surface along the x-axis given $y$ bounds

$ x = 1 + 2y^2$ , $ 1 \leq y \leq 2$

I sketched out a graph plotted some points to get a rough picture of the graph. So first things first, I think I need to find the x bounds, so I plug in y=1 and y=2 to find x.

$ x = 1 + 2(1)^2 = \textbf{3}$ and

$ x = 1 + 2(2)^2 = \textbf{5}$

Here is where I get confused setting up the integral.

I know that the surface area formula is $ $ S = \int 2\pi r ds$ $ where $ 2\pi r$ represents the circumference of the revolution around the x-axis and $ ds$ is the “thickness” of the same circle.

So I reason the formula to be setup like this

$ $ S = 2\pi \int_{3}^{5} x \frac{dx}{dy} =2\pi \int_{3}^{5} (1 + 2y^2)\sqrt{1 + (4y)^2}dy$ $ .

Is this correct? If so, this looks kind of difficult to integrate. Would integration by parts be my best choice here?

Need help for integrating the machine learning concept in javascript rule engines

I have a requirement to find the most frequently fired rules in the rule engine and place them at first in the rule hierarchy for a product configurator by using the features of machine learning. I have not found any information regarding this , would like to know if someone have any idea or have tried something similar to this.

Integrating CCAvenue

I am a totally new to payment gateways. I would like to integrate CCAvenue to mobile application back end in NodeJS. I have the kit from CCAvenue, I have to do non seamless integration, but I don’t have any idea about doing payment.

I would be thankful if anyone pointed to me to a tutorial other then the CCAvenue integration manual.