#How to file tds return without software | Explore Tumblr Posts and Blogs

delhi-7a · 3 years

Text

Best Inventory Management Software in 2021 For SMEs & MSMEs

Introduction

Establishing and running a business enterprise can be stressful and painful if you don’t have the right tool for better management. By mentioning the right tool here we mean the right inventory software for small business. We are very sure that now you must be wondering how exactly one can choose the best inventory management software for SMEs & MSMEs, right? If yes, then drop all your worries now and let us help you.

Getting confused while opting for the inventory tracking system for your business enterprise is a normal thing as there are a number of paid and free inventory software available in the marketplace. And inventory software for small business is really very necessary as they play an important role to drive a business towards success. Even a number of business experts call the inventory the backbone of any SME and MSME. While running any business, accuracy is the key and a high level of accuracy for inventory is a must. Just a single or even a minor error in inventory can cause unnecessary purchases, inadequate stocks, and shipment delays. So, to avoid all this unnecessary chaos, let’s take a look at “How to Choose the Right Inventory Software For SMEs & MSMEs”.

How to Choose the Right Inventory Software For SMEs & MSMEs?

Create a List of Your Business Needs and Challenges

Before investing in any inventory tracking system, we will recommend you prepare a list of your business requirements. It means that your list must highlight the needs and challenges of your business. This way, you will be able to choose the free Inventory Management Software in India which can easily focus upon all the pain points of your business. This list will even help you to determine the features that you want in your Inventory Control System. So, prepare this list as a first priority!

Server Based or Cloud-Based Inventory System

The very next thing that you need to consider is that if your business needs a Server Based or Cloud-Based free inventory management software India. Here, you need to think about which one of these two can bring more benefit to your business. If you are struggling on a tight budget, then Cloud-based can be a budget-friendly choice. And if there is no such case, then you can also go with the Server Based Inventory System or commonly referred to as the download version. Although we will recommend you the Marg Inventory Software which is considered as one of the best free Inventory Software of 2021 to easily manage the complete Inventory System of your Business Enterprise. Moreover, Marg Inventory software is available both online & offline.

Keep Your Inventory Management Policies in Mind

While choosing the right inventory tracking system for SME and MSME, one always needs to keep their Inventory Management Policies in mind to avoid post-purchase consequences. Every business has their own inventory management policies which define the movement of your products, how you track costs, and how to prevent losses or shortages. This is the best way to choose the free inventory management software in India which can perfectly fit within all the requirements of your business enterprise.

Take a Detailed Look at Features of the Inventory Control System

Features and functionalities of an Inventory Control System determine if your business will be able to meet the requirements of your customers or not. So, take a closer look at the different features and functionalities of the Inventory System that you have decided on for your business. Wisely evaluate different features of the system like scalability, capability, and quality. And when it comes to this, then the Marg Inventory System comes at the top of all. This efficient and extraordinary Inventory Control System has all the features that you need to manage the Inventory of your SME and MSME in 2021.

Top Reasons to Choose Marg Inventory System

Inventory Tracking

When it comes to the right inventory control system, then the Marg Inventory System is counted among the top Game Changers for any business. It simplifies all hectic tasks in just a few clicks of the button. It is quite reliable to keep track of all the saleable products, accessories, substitutes, and even expiry dates.

Barcode Scanning

This is one of the crucial features for any inventory system and Marg Inventory Control System is complemented with this feature to get rid of all the exhaustion that you face while manually keying SKUs. If you will ask about its compatibility, then you will be glad to know that it is compatible with various types of barcode scanners. So, no more exhaustion while adding SKUs, serial numbers, and batch numbers.

GST Ready Solution

If you are using the Marg Inventory Control System, then GST Billing and Return Filing can’t be hectic anymore. This advanced inventory software comes with GST Ready Solution which makes everything so easy. You can easily file GST Returns, TCS and TDS directly via GST Software.

Reliable Warehouse Management

If you are not using the right Inventory Control System for your Business enterprise, then everything becomes so hectic and the most hectic of all is Warehouse Management. Whereas, the Marg Inventory Software manages and tracks your stock in different warehouses, godowns, or shops so efficiently and effectively that you will have to worry about nothing at all.

Final Words!

All we will recommend you to do is don’t choose just any Inventory Control System without giving it careful consideration otherwise you will have to regret it and may also need to pay a heavy cost of this mistake. An Inventory Control System is the backbone of any business whether it is a Small-sized business or a Giant organization. Marg Inventory Management Software can also be a great choice for your SME and MSME as it comes with all the features that you may need to manage the Inventory of your business effectively and efficiently.

#best inventory management software #inventory management software free #free inventory management software india #inventory management software #inventory management software for business #inventory management software for smes #inventory management software for msmes #marg inventory management software

1 note · View note

seldo · 5 years

Text

Databases: how they work, and a brief history

My twitter-friend Simon had a simple question that contained much complexity: how do databases work?

Ok, so databases really confuse me, like how do databases even work?

— Simon Legg (@simonleggsays) November 18, 2019

I don't have a job at the moment, and I really love databases and also teaching things to web developers, so this was a perfect storm for me:

To what level of detail would you like an answer? I love databases.

— Laurie Voss (@seldo) November 18, 2019

The result was an absurdly long thread of 70+ tweets, in which I expounded on the workings and history of databases as used by modern web developers, and Simon chimed in on each tweet with further questions and requests for clarification. The result of this collaboration was a super fun tiny explanation of databases which many people said they liked, so here it is, lightly edited for clarity.

What is a database?

Let's start at the very most basic thing, the words we're using: a "database" literally just means "a structured collection of data". Almost anything meets this definition – an object in memory, an XML file, a list in HTML. It's super broad, so we call some radically different things "databases".

The thing people use all the time is, formally, a Database Management System, abbreviated to DBMS. This is a piece of software that handles access to the pile of data. Technically one DBMS can manage multiple databases (MySQL and postgres both do this) but often a DBMS will have just one database in it.

Because it's so frequent that the DBMS has one DB in it we often call a DBMS a "database". So part of the confusion around databases for people new to them is because we call so many things the same word! But it doesn't really matter, you can call an DBMS a "database" and everyone will know what you mean. MySQL, Redis, Postgres, RedShift, Oracle etc. are all DBMS.

So now we have a mental model of a "database", really a DBMS: it is a piece of software that manages access to a pile of structured data for you. DBMSes are often written in C or C++, but it can be any programming language; there are databases written in Erlang and JavaScript. One of the key differences between DBMSes is how they structure the data.

Relational databases

Relational databases, also called RDBMS, model data as a table, like you'd see in a spreadsheet. On disk this can be as simple as comma-separated values: one row per line, commas between columns, e.g. a classic example is a table of fruits:

apple,10,5.00 orange,5,6.50

The DBMS knows the first column is the name, the second is the number of fruits, the third is the price. Sometimes it will store that information in a different database! Sometimes the metadata about what the columns are will be in the database file itself. Because it knows about the columns, it can handle niceties for you: for example, the first column is a string, the second is an integer, the third is dollar values. It can use that to make sure it returns those columns to you correctly formatted, and it can also store numbers more efficiently than just strings of digits.

In reality a modern database is doing a whole bunch of far more clever optimizations than just comma separated values but it's a mental model of what's going on that works fine. The data all lives on disk, often as one big file, and the DBMS caches parts of it in memory for speed. Sometimes it has different files for the data and the metadata, or for indexes that make it easier to find things quickly, but we can safely ignore those details.

RDBMS are older, so they date from a time when memory was really expensive, so they usually optimize for keeping most things on disk and only put some stuff in memory. But they don't have to: some RDBMS keep everything in memory and never write to disk. That makes them much faster!

Is it still a database if all the structured data stays in memory? Sure. It's a pile of structured data. Nothing in that definition says a disk needs to be involved.

So what does the "relational" part of RDBMS mean? RDBMS have multiple tables of data, and they can relate different tables to each other. For instance, imagine a new table called "Farmers":

IDName 1bob 2susan

and we modify the Fruits table:

Farmer IDFruitQuantityPrice 1apple105.00 1orange56.50 2apple206.00 2orange14.75

.dbTable { border: 1px solid black; } .dbTable thead td { background-color: #eee; } .dbTable td { padding: 0.3em; }

The Farmers table gives each farmer a name and an ID. The Fruits table now has a column that gives the Farmer ID, so you can see which farmer has which fruit at which price.

Why's that helpful? Two reasons: space and time. Space because it reduces data duplication. Remember, these were invented when disks were expensive and slow! Storing the data this way lets you only list "susan" once no matter how many fruits she has. If she had a hundred kinds of fruit you'd be saving quite a lot of storage by not repeating her name over and over. The time reason comes in if you want to change Susan's name. If you repeated her name hundreds of times you would have to do a write to disk for each one (and writes were very slow at the time this was all designed). That would take a long time, plus there's a chance you could miss one somewhere and suddenly Susan would have two names and things would be confusing.

Relational databases make it easy to do certain kinds of queries. For instance, it's very efficient to find out how many fruits there are in total: you just add up all the numbers in the Quantity column in Fruits, and you never need to look at Farmers at all. It's efficient and because the DBMS knows where the data is you can say "give me the sum of the quantity colum" pretty simply in SQL, something like SELECT SUM(Quantity) FROM Fruits. The DBMS will do all the work.

NoSQL databases

So now let's look at the NoSQL databases. These were a much more recent invention, and the economics of computer hardware had changed: memory was a lot cheaper, disk space was absurdly cheap, processors were a lot faster, and programmers were very expensive. The designers of newer databases could make different trade-offs than the designers of RDBMS.

The first difference of NoSQL databases is that they mostly don't store things on disk, or do so only once in a while as a backup. This can be dangerous – if you lose power you can lose all your data – but often a backup from a few minutes or seconds ago is fine and the speed of memory is worth it. A database like Redis writes everything to disk every 200ms or so, which is hardly any time at all, while doing all the real work in memory.

A lot of the perceived performance advantages of "noSQL" databases is just because they keep everything in memory and memory is very fast and disks, even modern solid-state drives, are agonizingly slow by comparison. It's nothing to do with whether the database is relational or not-relational, and nothing at all to do with SQL.

But the other thing NoSQL database designers did was they abandoned the "relational" part of databases. Instead of the model of tables, they tended to model data as objects with keys. A good mental model of this is just JSON:

[ {"name":"bob"} {"name":"susan","age":55} ]

Again, just as a modern RDBMS is not really writing CSV files to disk but is doing wildly optimized stuff, a NoSQL database is not storing everything as a single giant JSON array in memory or disk, but you can mentally model it that way and you won't go far wrong. If I want the record for Bob I ask for ID 0, Susan is ID 1, etc..

One advantage here is that I don't need to plan in advance what I put in each record, I can just throw anything in there. It can be just a name, or a name and an age, or a gigantic object. With a relational DB you have to plan out columns in advance, and changing them later can be tricky and time-consuming.

Another advantage is that if I want to know everything about a farmer, it's all going to be there in one record: their name, their fruits, the prices, everything. In a relational DB that would be more complicated, because you'd have to query the farmers and fruits tables at the same time, a process called "joining" the tables. The SQL "JOIN" keyword is one way to do this.

One disadvantage of storing records as objects like this, formally called an "object store", is that if I want to know how many fruits there are in total, that's easy in an RDBMS but harder here. To sum the quantity of fruits, I have to retrieve each record, find the key for fruits, find all the fruits, find the key for quantity, and add these to a variable. The DBMS for the object store may have an API to do this for me if I've been consistent and made all the objects I stored look the same. But I don't have to do that, so there's a chance the quantities are stored in different places in different objects, making it quite annoying to get right. You often have to write code to do it.

But sometimes that's okay! Sometimes your app doesn't need to relate things across multiple records, it just wants all the data about a single key as fast as possible. Relational databases are best for the former, object stores the best for the latter, but both types can answer both types of questions.

Some of the optimizations I mentioned both types of DBMS use are to allow them to answer the kinds of questions they're otherwise bad at. RDBMS have "object" columns these days that let you store object-type things without adding and removing columns. Object stores frequently have "indexes" that you can set up to be able to find all the keys in a particular place so you can sum up things like Quantity or search for a specific Fruit name fast.

So what's the difference between an "object store" and a "noSQL" database? The first is a formal name for anything that stores structured data as objects (not tables). The second is... well, basically a marketing term. Let's digress into some tech history!

The self-defeating triumph of MySQL

Back in 1995, when the web boomed out of nowhere and suddenly everybody needed a database, databases were mostly commercial software, and expensive. To the rescue came MySQL, invented 1995, and Postgres, invented 1996. They were free! This was a radical idea and everybody adopted them, partly because nobody had any money back then – the whole idea of making money from websites was new and un-tested, there was no such thing as a multi-million dollar seed round. It was free or nothing.

The primary difference between PostgreSQL and MySQL was that Postgres was very good and had lots of features but was very hard to install on Windows (then, as now, the overwhelmingly most common development platform for web devs). MySQL did almost nothing but came with a super-easy installer for Windows. The result was MySQL completely ate Postgres' lunch for years in terms of market share.

Lots of database folks will dispute my assertion that the Windows installer is why MySQL won, or that MySQL won at all. But MySQL absolutely won, and it was because of the installer. MySQL became so popular it became synonymous with "database". You started any new web app by installing MySQL. Web hosting plans came with a MySQL database for free by default, and often no other databases were even available on cheaper hosts, which further accelerated MySQL's rise: defaults are powerful.

The result was people using mySQL for every fucking thing, even for things it was really bad at. For instance, because web devs move fast and change things they had to add new columns to tables all the time, and as I mentioned RDBMS are bad at that. People used MySQL to store uploaded image files, gigantic blobs of binary data that have no place in a DBMS of any kind.

People also ran into a lot of problems with RDBMS and MySQL in particular being optimized for saving memory and storing everything on disk. It made huge databases really slow, and meanwhile memory had got a lot cheaper. Putting tons of data in memory had become practical.

The rise of in-memory databases

The first software to really make use of how cheap memory had become was Memcache, released in 2003. You could run your ordinary RDBMS queries and just throw the results of frequent queries into Memcache, which stored them in memory so they were way, WAY faster to retrieve the second time. It was a revolution in performance, and it was an easy optimization to throw into your existing, RDBMS-based application.

By 2009 somebody realized that if you're just throwing everything in a cache anyway, why even bother having an RDBMS in the first place? Enter MongoDB and Redis, both released in 2009. To contrast themselves with the dominant "MySQL" they called themselves "NoSQL".

What's the difference between an in-memory cache like Memcache and an in-memory database like Redis or MongoDB? The answer is: basically nothing. Redis and Memcache are fundamentally almost identical, Redis just has much better mechanisms for retrieving and accessing the data in memory. A cache is a kind of DB, Memcache is a DBMS, it's just not as easy to do complex things with it as Redis.

Part of the reason Mongo and Redis called themselves NoSQL is because, well, they didn't support SQL. Relational databases let you use SQL to ask questions about relations across tables. Object stores just look up objects by their key most of the time, so the expressiveness of SQL is overkill. You can just make an API call like get(1) to get the record you want.

But this is where marketing became a problem. The NoSQL stores (being in memory) were a lot faster than the relational DBMS (which still mostly used disk). So people got the idea that SQL was the problem, that SQL was why RDBMS were slow. The name "NoSQL" didn't help! It sounded like getting rid of SQL was the point, rather than a side effect. But what most people liked about the NoSQL databases was the performance, and that was just because memory is faster than disk!

Of course, some people genuinely do hate SQL, and not having to use SQL was attractive to them. But if you've built applications of reasonable complexity on both an RDBMS and an object store you'll know that complicated queries are complicated whether you're using SQL or not. I have a lot of love for SQL.

If putting everything in memory makes your database faster, why can't you build an RDBMS that stores everything in memory? You can, and they exist! VoltDB is one example. They're nice! Also, MySQL and Postgres have kind of caught up to the idea that machines have lots more RAM now, so you can configure them to keep things mostly in memory too, so their default performance is a lot better and their performance after being tuned by an expert can be phenomenal.

So anything that's not a relational database is technically a "NoSQL" database. Most NoSQL databases are object stores but that's really just kind of a historical accident.

How does my app talk to a database?

Now we understand how a database works: it's software, running on a machine, managing data for you. How does your app talk to the database over a network and get answers to queries? Are all databases just a single machine?

The answer is: every DBMS, whether relational or object store, is a piece of software that runs on machine(s) that hold the data. There's massive variation: some run on 1 machine, some on clusters of 5-10, some run across thousands of separate machines all at once.

The DBMS software does the management of the data, in memory or on disk, and it presents an API that can be accessed locally, and also more importantly over the network. Sometimes this is a web API like you're used to, literally making GET and POST calls over HTTP to the database. For other databases, especially the older ones, it's a custom protocol.

Either way, you run a piece of software in your app, usually called a Client. That client knows the protocol for talking to the database, whether it's HTTP or WhateverDBProtocol. You tell it where the database server is on the network, it sends queries over and gets responses. Sometimes the queries are literally strings of text, like "SELECT * FROM Fruits", sometimes they are JSON payloads describing records, and any number of other variations.

As a starting point, you can think of the client running on your machine talking over the network to a database running on another machine. Sometimes your app is on dozens of machines, and the database is a single IP address with thousands of machines pretending to be one machine. But it works pretty much the same either way.

The way you tell your client "where" the DB is is your connection credentials, often expressed as a string like "http://username:[email protected]:1234" or "mongodb://...". But this is just a convenient shorthand. All your client really needs to talk to a database is the DNS name (like mydb.com) or an IP address (like 205.195.134.39), plus a port (1234). This tells the network which machine to send the query to, and what "door" to knock on when it gets there.

A little about ports: machines listen on specific ports for things, so if you send something to port 80, the machine knows the query is for your web server, but if you send it to port 1234, it knows the query is for your database. Who picks 1234 (In the case of Postgres, it's literally 5432)? There's no rhyme or reason to it. The developers pick a number that's easy to remember between 1 and 65,535 (the highest port number available) and hope that no other popular piece of software is already using it.

Usually you'll also have a username and password to connect to the database, because otherwise anybody who found your machine could connect to your database and get all the data in it. Forgetting that this is true is a really common source of security breaches!

There are bad people on the internet who literally just try every single IP in the world and send data to the default port for common databases and try to connect without a username or password to see if they can. If it works, they take all the data and then ransom it off. Yikes! Always make sure your database has a password.

Of course, sometimes you don't talk to your database over a network. Sometimes your app and your database live on the same machine. This is common in desktop software but very rare in web apps. If you've ever heard of a "database driver", the "driver" is the equivalent of the "client", but for talking to a local database instead of over a network.

Replication and scaling

Remember I said some databases run on just 1 machine, and some run on thousands of machines? That's known as replication. If you have more than one copy of a piece of data, you have a "replica" of that data, hence the name.

Back in the old days hardware was expensive so it was unusual to have replicas of your data running at the same time. It was expensive. Instead you'd back up your data to tape or something, and if the database went down because the hardware wore out or something, then you'd buy new hardware and (hopefully) reinstall your DBMS and restore the data in a few hours.

Web apps radically changed people's demands of databases. Before web apps, most databases weren't being continuously queried by the public, just a few experts inside normal working hours, and they would wait patiently if the database broke. With a web app you can't have minutes of downtime, far less hours, so replication went from being a rare feature of expensive databases to pretty much table stakes for every database. The initial form of replication was a "hot spare".

If you ran a hot spare, you'd have your main DBMS machine, which handled all queries, and a replica DBMS machine that would copy every single change that happened on the primary to itself. Primary was called m****r and the replica s***e because the latter did whatever the former told it to do, and at the time nobody considered how horrifying that analogy was. These days we call those things "primary/secondary" or "primary/replica" or for more complicated arrangements things like "root/branch/leaf".

Sometimes, people would think having a hot spare meant they didn't need a backup. This is a huge mistake! Remember, the replica copies every change in the main database. So if you accidentally run a command that deletes all the data in your primary database, it will automatically delete all the data in the replica too. Replicas are not backups, as the bookmarking site Magnolia famously learned.

People soon realized having a whole replica machine sitting around doing nothing was a waste, so to be more efficient they changed where traffic went: all the writes would go to the primary, which would copy everything to the replicas, and all the reads would go to the replicas. This was great for scale!

Instead of having 1 machine worth of performance (and you could swap to the hot spare if it failed, and still have 1 machine of performance with no downtime) suddenly you had X machines of performance, where X could be dozens or even hundreds. Very helpful!

But primary/secondary replication of this kind has two drawbacks. First, if a write has arrived at the primary database but not yet replicated to all the secondary machines (which can take half a second if the machines are far apart or overloaded) then somebody reading from the replica can get an answer that's out of date. This is known as a "consistency" failure, and we'll talk about it more later.

The second flaw with primary/second replication is if the primary fails, suddenly you can no longer write to your database. To restore the ability to do writes, you have to take one of the replicas and "promote" it to primary, and change all the other replicas to point at this new primary box. It's time-consuming and notoriously error-prone.

So newer databases invented different ways of arranging the machines, formally called "network topology". If you think of the way machines connect to each other as a diagram, the topology is the shape of that diagram. Primary/secondary looks like a star. Root/branch/leaf looks like a tree. But you can have a ring structure, or a mesh structure, or lots of others. A mesh structure is a lot of fun and very popular, so let's talk about more about them.

Mesh replication databases

In a mesh structure, every machine is talking to every other machine and they all have some portion of the data. You can send a write to any machine and it will either store it, or figure out what machine should store it and send it to that machine. Likewise, you can query any machine in the mesh, and it will give you the answer if it has the data, or forward your request to a machine that does. There's no "primary" machine to fail. Neat!

Because each machine can get away with storing only some of the data and not all of it, a mesh database can store much, much more data than a single machine could store. If 1 machine could store X data, then N machines could theoretically store N*X data. You can almost scale infinitely that way! It's very cool.

Of course, if each record only existed on one machine, then if that machine failed you'd lose those records. So usually in a mesh network more than one machine will have a copy of any individual record. That means you can lose machines without losing data or experiencing downtime; there are other copies lying around. In some mesh databases can also add a new machine to the mesh and the others will notice it and "rebalance" data, increasing the capacity of the database without any downtime. Super cool.

So a mesh topology is a lot more complicated but more resilient, and you can scale it without having to take the database down (usually). This is very nice, but can go horribly wrong if, for instance, there's a network error and suddenly half the machines can't see the other half of the machines in the mesh. This is called a "network partition" and it's a super common failure in large networks. Usually a partition will last only a couple of seconds but that's more than enough to fuck up a database. We'll talk about network partitions shortly.

One important question about a mesh DB is: how do you connect to it? Your client needs to know an IP address to connect to a database. Does it need to know the IP addresses of every machine in the mesh? And what happens when you add and remove machines from the mesh? Sounds messy.

Different Mesh DBs do it differently, but usually you get a load balancer, another machine that accepts all the incoming connections and works out which machine in the mesh should get the question and hands it off. Of course, this means the load balancer can fail, hosing your DB. So usually you'll do some kind of DNS/IP trickery where there are a handful of load balancers all responding on the same domain name or IP address.

The end result is your client magically just needs to know only one name or IP, and that IP always responds because the load balancer always sends you to a working machine.

CAP theory

This brings us neatly to a computer science term often used to talk about databases which is Consistency, Availability, and Partition tolerance, aka CAP or "CAP theory". The basic rule of CAP theory is: you can't have all 3 of Consistency, Availability and Partition Tolerance at the same time. Not because we're not smart enough to build a database that good, but because doing so violates physics.

Consistency means, formally: every query gets the correct, most up-to-date answer (or an error response saying you can't have it).

Availability means: every query gets an answer (but it's not guaranteed to be the correct one).

Partition Tolerance means: if the network craps out, the database will continue to work.

You can already see how these conflict! If you're 100% Available it means by definition you'll never give an error response, so sometimes the data will be out of date, i.e. not Consistent. If your database is Partition Tolerant, on the other hand, it keeps working even if machine A can't talk to machine B, and machine A might have a more recent write than B, so machine B will give stale (i.e. not Consistent) responses to keep working.

So let's think about how CAP theorem applies across the topologies we already talked about.

A single DB on a single machine is definitely Consistent (there's only one copy of the data) and Partition Tolerant (there's no network inside of it to crap out) but not Available because the machine itself can fail, e.g. the hardware could literally break or power could go out.

A primary DB with several replicas is Available (if one replica fails you can ask another) and Partition Tolerant (the replicas will respond even if they're not receiving writes from the primary) but not Consistent (because as mentioned earlier, the replicas might not have every primary write yet).

A mesh DB is extremely Available (all the nodes always answer) and Partition Tolerant (just try to knock it over! It's delightfully robust!) but can be extremely inconsistent because two different machines on the mesh could get a write to the same record at the same time and fight about which one is "correct".

This is the big disadvantage to mesh DBs, which otherwise are wonderful. Sometimes it's impossible to know which of two simultaneous writes is the "winner". There's no single authority, and Very Very Complicated Algorithms are deployed trying to prevent fights breaking out between machines in the mesh about this, with highly variable levels of success and gigantic levels of pain when they inevitably fail. You can't get all three of CAP and Consistency is what mesh networks lose.

In all databases, CAP isn't a set of switches where you are or aren't Consistent, Available, or Partition Tolerant. It's more like a set of sliders. Sliding up the Partition Tolerance generally slides down Consistency, sliding down Availability will give you more Consistency, etc etc.. Every DBMS picks some combination of CAP and picking the right database is often a matter of choosing what CAP combination is appropriate for your application.

Other topologies

Some other terms you frequently hear in the world of databases are "partitions" (which are different from the network partitions of CAP theorem) and "shards". These are both additional topologies available to somebody designing a database. Let's talk about shards first.

Imagine a primary with multiple replicas, but instead of each replica having all the data, each replica has a slice (or shard) of the data. You can slice the data lots of ways. If the database was people, you could have 26 shards, one with all names starting with A, one with all the names starting with B, etc..

Sharding can be helpful if the data is too big to all fit on one disk at a time. This is less of a problem than it used to be because virtual machines these days can effectively have infinity-sized hard drives.

The disadvantage of sharding is it's less Available: if you lose a shard, you lose everybody who starts with that letter! (Of course, your shards can also have replicas...) Plus your software needs to know where all the shards are and which one to ask a question. It's fiddly. Many of the problems of sharded databases are solved by using mesh topologies instead.

Partitions are another way of splitting up a database, but instead of splitting it across many machines, it splits the database across many files in a single machine. This is an old pattern that was useful when you had really powerful hardware and really slow disks, because you could install multiple disks into a single machine and put different partitions on each one, speeding up your achingly slow, disk-based database. These days there's not a lot of reason to use partitions of this kind.

Fin

That concludes this impromptu Databases 101 seminar! I hope you enjoyed learning a little bit more about this fantastically fun and critically important genre of software. from Seldo.Com Feed https://ift.tt/32XwZth

#blog #import

1 note · View note

arjunvmurali · 2 years

Text

Tally Prime Certification Benefits

Tally prime is the latest updated version of Tally accounting software. Tally Prime helps you manage accounting, banking taxation, inventory, payroll, and much more in a much easier way, which results in your business growth.

Chartered accountants, business owners and other tally users can use this software to manage their work without any hardships and make everyday simple. It is mainly used for small and medium businesses.

Tally Prime comes with a lot more features than its predecessor Tally ERP 9.

Helps in business growth: New features like "go-to" and "customisable reports" have been added to Tally Prime. You can discover and look at reports according to your convenience without going back for fear of missing some data. In Tally Prime, you can manage multiple businesses, multi-currency, multiple godowns, order processes, cost centres etc., which will help in reduction in complexity and thus, you can focus more on business growth.

2. Better control over cash flow: You can easily manage your payment timelines when your bills are receivable and payable quickly and without any trouble. Quick, insightful reports make you a better decision making person and can fully concentrate on your business without worrying about its accounts sections. Moreover, your cash flow can be optimised as this software helps in easy and efficient stock movement.

3. Better business efficiency: Tally Prime works super fast. So you get more time to do other things and work efficiently. You can multitask using this software and print or view the reports in the middle of the voucher entry. You can manage another company's account without leaving the current company activity, understand the problems in each and every report, and much more. You do not have to remember shortcut keys, making your workflow consistent and faster.

4. Tax compliance is made easy: your books will always be correct using Tally Prime's correction, detection and prevention mechanism, which will give you the confidence that your file returns are always accurate.

5. User-friendly software: Tally Prime is designed in a simple manner and can be used by both non-IT and non-account background people. Things like discovering information, consistent options and navigating without much thinking about the path have made this software a favourite among its users.

6. Mobile friendly: Another feature of Tally Prime is mobile friendly. It can be operated on all devices like laptops, tablets and mobile. So you can be tension free when you are travelling, as you can check your reports from mobile using Tally Prime.

7. Safety of data: This software is made mainly by keeping in mind the safety and security of the data. Since multiple business data can be entered at a time, data safety is essential. No data leakage will happen even if there are unavoidable situations like network interruptions or power failures.

How to set up Tally Prime?

Installing Tally Prime is just a few clicks away. You can setup Tally Prime in 3 steps:

Download

Install

Start transacting right away

Tally Prime is so simple to use, and you can use it yourself. But if you still find it challenging to use or are not having enough time, you can hire a Tally Prime certified Accountant. Many institutes are offering Tally Prime Certification Courses.

Finprov learning institute provides a Tally Prime certification course where you will learn about using Tally Prime in detail. Here you will learn about

familiarising the Tally Prime interface

generating MIS Reports, "go to" feature

Training on Inventory, Payroll and GST in Tally, TDS and TCS

features and benefits and setting up of Tally Prime

Job costing, cost centre and cost categories

vouchers, banking utilities and other essential tools and features

It is a one month course covering the entire Tally Prime software and making you a pro in using it. The course fee is around Rs 10000. It is available offline and is in the Malayalam language.

#finance #accounting #certification course

0 notes

ayushi123 · 3 years

Link

0 notes

theneusource-blog · 4 years

Text

What is ITR e-Filing and How it is Important for Each One of Us?

Income Tax Filing Online is a must for all. E-filing is a system for submitting tax documents to India through the use of the internet or direct connection, usually without the need to submit any paper documents. Tax preparation software with e-filing capabilities includes stand-alone programs or websites. Simply stating, e-filing or electronic filing is submitting your income tax returns online. There are two ways to file your income tax returns. The traditional way is the offline way, where you go to the Income Tax Department’s office to physically file your returns.

To upload ITR, i.e., Income Tax Returns, there are certain steps to be followed.

● Download the ITR preparation software for the relevant assessment year to your desktop/laptop from the “Download’s” page.

● Prepare the Return using the downloaded Software.

● Gather all the information regarding your income, tax payments, deductions, etc.

● Pre-populate the personal details and tax payments or TDS by clicking on the “Pre-fill” button.

● Compare with the information you have to ensure that nothing is left out.

● Enter all the relevant data and click on “Calculate” to compute the tax and interest liability and final figure of Refund or Tax payable.

● If Tax is payable, do not forget to pay immediately and enter the details in the appropriate schedule.

● Repeat the above steps so that tax payable becomes zero.

● Generate and save the Income Tax Return data in XML format in the desired path or place on your laptop/ desktop.

● Login to e-filing website with- User ID, Password, Date of Birth or Date of Incorporation and enter the Captcha code.

● Go to e-file and click on “Upload Return”.

● Select the appropriate Tax Return, Assessment Year and XML file previously saved in the steps mentioned above, using the Browse button.

● Upload Digital Signature Certificate (DSC), if applicable.

● Please ensure that the DSC is registered with e-Filing.

● Click on the “Submit” button.

● On successful admission, return Form -V would be displayed if the signature certificate is not used.

● Click on the link and download the return form-V.

● Income Tax Return-V will also be sent to the registered e-mail.

● If it is uploaded with a certificate, the Return Filing process is complete.

● And when the return is not uploaded with it, the ITR-V Form should be printed, signed and submitted to CPC within 120 days from the date of e-Filing.

● The return will be processed only upon the receipt of the signed tax return Form-V.

● Please check your e-mails or SMS for reminders on non-receipt of Income Tax Form-V.

● The upload of the Tax Return process is complete now.

Only forms 1 and 4S can be filed online. Please ensure that the DSC is registered with e-Filing.

This ends the process of preparing and submitting tax returns online by the Taxpayer.

One is to download the application Income Tax form, fill, save and then upload it. Another is filing the online. Only ITR 1 and 4 forms, filed by the individual taxpayers, can be filled online without downloading any software. There are two ways you can file your return online.

Income Tax Online Submission is now mandatory for individuals and Hindu Undivided Families whose accounts have to be audited under Section 44AB of the Income Tax Act, 1961. For companies, e-filing with digital signature is mandatory. You can also use the tax return preparation spreadsheet provided on the IT department website.

One basic advantage of using e-filing is speed. For instance, when filing your tax income, using the internet and emailing tax forms directly to the IRS will only take a few minutes.

#Income Tax Filing Online #Income Tax Online Submission #Online Filing Income Tax #Income Tax Filing Online India #Income Tax E Filing Site #Filing Online Income Tax Return in India

0 notes

soniakapoor636 · 5 years

Text

Know How Accounting Made Easy For Startups

Irrespective of the size of the business and the industry to which it belongs, accounts and finance are indispensable for its functioning. Like all other aspects of business, at present accounting is being done in digital format through Tally.

‘Tally ERP 9 single user’offered by the leading certified tally provider has comprehensive capabilities to primarily serve small and medium-sized businesses and startups. It is recognized for its power of simplicity, helps to get a bird’s eye view of business, and is GST-compliant. It provides startups, an automated solution for maintaining records and helps them to be compliant with rules and regulations with no license renewal fees. Tally ERP 9 makes a significant contribution to the growth of startups and it is the ideal business companion which makes accounting easy.

How startups benefit from Tally ERP 9?

Ø Simplicity: Tally ERP is extremely simple to work with.All you need to do is just install the software, activate the license, and start running your business without any prerequisites, procedures, or set rules.

Ø Managing accounts easily: To manage working capital or control inventory, Tally ERP 9 adapts the unique ways of your business. The best Tally ERP solution in Mumbai provides a crystal clear visibility of the various aspects of business and runs the complex parts like accounting and compliance. It is easy to learn and requires minimum resources during implementation.

Ø Simplified tax return and GST: As a business owner, you can completely rely on Tally to file your GST returns easily and correctly with less chances of rejection. It also helps with TDS returns, VAT filing, excise tax, service tax returns for all small businesses and startups.

Ø Maintain Budget: Usually startups work with a limited budget and tally helps them to work and manage expenses, so that the company does not indulge in spending more money.

Ø Makes banking easy: Manual bank reconciliations may give rise to errors but Tally ERP 9 offers automated back reconciliations that is free from errors and saves time. It enables you to print cheques of any bank, keep track of the status of all postdated cheques, and generate cash deposit slips.

Ø Faster decisions: When your business starts to grow, you are required to make faster decisions backed by accurate data. It provides instant reports on stock aging, analysis, price estimates, profit analysis, and other critical overviews.The reports can be designed with the most advanced filters, comparisons, and alteration tools.

Ø Speed: Reports like balance sheet, profit and loss statement, stock summary, and other critical reports takes a lot of time when prepared manually. With the use of Tally, it can be generated accurately within minutes.

Ø Reliability: This resilient software is immune to virus attacks and as a result of your data always remains updated, safe, and secure.

Ø Data security: When data is entered in Tally, there is no chance of data getting tampered or altered. Therefore, the data entered in Tally remains secured.

Ø Data retrieval: Data once stored can be retrieved easily because Tally ERP 9 saves all invoices, bills, vouchers, and receipts in its archive folder.

Ø An audit tool: It is also a tool for conducting an audit. It carries out a thorough compliance check at the beginning of the financial year and ensures all financial transactions are smoothly being done.

End Credits

Tally ERP 9 single user is a great investment for startups, as it simplifies the process of recording financial transactions and operates at high speed with minimal user training.

#Certified Tally Provider #Tally Server 9 features #Tally Single User #Tally Solutions GST #Tally Dealers in Mumbai

0 notes

marcosplavsczyk · 4 years

Link

Many developers, during their work, are required from their superiors to export MySQL data to various file formats like Excel, CSV, JSON, or HTML file.

In this article, a couple of ways to export MySQL data to HTML file format will be shown. First, export steps will be explained by using MySQL functionality via the command-line. Next, HTML options for export MySQL data will be shown using features from the ApexSQL Database Power Tool for VS Code, the third-party extension.

The following methods for exporting will be used:

Using HTML option from the command-line

Export to HTML using a third-party software

Export results from the Results grid

Export results from Text search result grid

Export results from Object search result grid

To see other export functionalities aside from HTML, please see the following articles:

Exporting MySQL data to CSV file format using different methods

How to export MySQL data to JSON

How to export/import MySQL data to Excel

For the purpose of this article, an example below will be used:

CREATE DATABASE `employees` CREATE TABLE `employees_address` ( `address_id` int(11) NOT NULL AUTO_INCREMENT, `location` varchar(100) NOT NULL, `location2` varchar(150) DEFAULT NULL, PRIMARY KEY (`address_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 INSERT INTO employees_address VALUES (NULL, '1586 1700 W Blancke St', '30 Commercial Road'), (NULL, '934 San Felipe de Puerto Plata Street', 'Piedras 623'), (NULL, 'Avenida João Jorge, 112, ap. 31', '219–241 Cleveland St');

Export MySQL data using the command-line

By default, MySQL returns query results in text table format. To generates a query results in an HTML table format, use the -H (or –HTML) option:

mysql -H -u root -p -h 127.0.0.1 -P 3309

Now, when logged on MySQL Server, pick a database and table from which data should be shown in HTML file format. In our case, the employees database and the employees_address table will be used:

Execute the following code:

SELECT * FROM employees_address;

The output will be something like this:

<TABLE BORDER=1><TR><TH>address_id</TH><TH>location</TH><TH>location2</TH></TR><TR><TD>1</TD><TD>1586 1700 W Blancke St</TD><TD>30 Commercial Road</TD></TR><TR><TD>2</TD><TD>934 San Felipe de Puerto Plata Street</TD><TD>Piedras 623</TD></TR><TR><TD>3</TD><TD>Avenida João Jorge, 112, ap. 31</TD><TD>219?241 Cleveland St</TD></TR></TABLE>

Copy that code in a text editor (e.g. Notepad) and save it as a .html file:

The output will look like this when opened in a browser:

To create output that contains only data values and suppress the column header, use the –skip-column-names option.

Lat’s connect to MySQL using this option:

mysql -H –skip-column-names -u root -p -h 127.0.0.1 -P 3309

Now, when the SELECT statement is executed:

SELECT * FROM employees_address;

As the result, only the data values without column header will appear:

<TABLE BORDER=1><TR><TR><TD>1</TD><TD>1586 1700 W Blancke St</TD><TD>30 Commercial Road</TD></TR><TR><TD>2</TD><TD>934 San Felipe de Puerto Plata Street</TD><TD>Piedras 623</TD></TR><TR><TD>3</TD><TD>Avenida João Jorge, 112, ap. 31</TD><TD>219?241 Cleveland St</TD></TR></TABLE>

When this is saved and opened as the HTML file, it will look like this:

Using a third-party extension to export MySQL data

With ApexSQL Database Power Tools for VS Code, there are different ways to export MySQL data to HTML file format.

First things first, use ApexSQL Database Power Tools for VS Code connection dialog to connect to the desired MySQL Server that contains the databases with data that should be exported in the desired file format. Currently, extension support exports to Excel, CSV, JSON, and HTML file format:

More details about the extension, how it can be installed, and used in VS Code can be found on the ApexSQL Database Power Tools for VS Code for a first-time user article

Once the connection with MySQL server is established, in ApexSQL server explorer, drill down to the desired database, right-click and, from the context menu, choose the New query command:

In the newly opened query editor, type and then execute a query:

SELECT * FROM employees_address;

In the top right corner of the Results query grid, options for exporting data from the Results query grid are placed to different file formats, and among these options, the HTML export option is included. Click the Export to HTML button, in the Save as dialog, enter a name for the HTML file and location where the file will be saved. Click Save to continue:

In the bottom right corner of VS Code, click the Show button to direct open location to the saved HTML file:

The exported data will look like this:

In case you want to search and export to HTML just particular data from MySQL database, the Export to HTML option from the Text search feature can be very handy.

In ApexSQL server explorer, right-click on a database, and from the context menu, choose the Text search command:

The Text search pane will be opened. Here in the Search phrase box, enter the text that needs to be looked for and, in the search grid, check the tables over which the search will be performed. In our case, that will be an employees_address table. Click the Find button. All matches with the set phrase from the Search phrase box will be listed in the search result grid. In this case, only one result will be shown:

To export that data to HTML, in the top right corner of the search result grid, click the Export to HTML button, set a name and location for the file and click the Save button:

The output will be like this:

Furthermore, if we are interested to find and export only particular objects from a database, the Object search feature can be used for such a task.

Under the ApexSQL server explorer pane, right-click on a database, and from the context menu, select the Object search command:

Once the Object search pane is opened in the Search phrase box, enter a name or part of the object name, specify where the search is by checking the Object name or Object bodies checkboxes and which of object types needs to be searched by checking the options under the Search for object types section. The result will be shown in the object search result grid:

The Export to HTML button is in the same location as it is described previously for the Test search feature.

Click the Export to HTML button and save the results on the desired location. The exported data will be like from the image below:

Conclusion

ApexSQL Database Power Tools for VS Code is a handy database management extension for developers using this IDE. In this article, we’ve seen how MySQL data can be exported to HTML file format using the native way and an easier way using the features from this extension. Not only HTML file format is supported, but also some other popular formats too.

#SQL Solution Center

0 notes

nisarifdah · 4 years

Text

Last, Insert Data into MySQL using PHP and Arduino IDE

Hello! Perhaps this is my last project for this semester because the semester has finished! And all I must do is only pass the examination and hoping for the best result of this semester. Aamiin.

I want to start this post with expressing my greatest thank to my Embedded System’s lecturer, Mr Kusprasapta Mutijarsa for encouraging my class to mess with ESP32, learn a much about it, and soon to be implementing to our life. I hope so. Last year when I was a fresh year student, I had PRD class (similar to this class) but I think I didn’t get anything from the class. I’m still feeling strange with Arduino, I don’t know how embedded system works, even I don’t know there is a development board exist in this world except for Arduino Board. But after I take Embedded System class this semester, I’m feeling enlightened by the hands-on. I feel familiar with Arduino IDE, I know more about the embedded system, and also I FEEL THE BURNING SENSOR FOR MY LIFE okay this is a very interesting experience for me.

And also I want to deliver my thank to my group partner, Grace and Naomi for helping the project from the start until now. You can check their blog on this link!

Grace’s blog: https://coretangrace.blogspot.com/

Naomi’s blog: https://naomiylnd.wixsite.com/mysite

Okay, next. Enough for chitchat.

So this project is building an ESP32 client that makes an HTTP post request to a PHP script to insert data into MySQL Database. As usual this project according to randomnerdtutorial.com link. But I’m using DHT 11 sensor which is quite different from the link. If you using DHT 11 too, you can follow my code for Arduino IDE because the code provided by randomnerdtutorial is for BME280 sensor.

Okay let’s get started with these steps: 1. Hosting your PHP application and MySQL Database. For this step, you can use Bluehost/digital ocean. But for this project, my classmate initiates to use his old domain for all class participant so I join to his domain.

2. Prepare MySQL Database

3. Insert Data in MySQL Database You can use cPanel or other to set the MySQL Database. But my friend domain using cPanel so I’ll show the step using cPanel. Search “File Manager”, select public_html option and press the “+ File” to create a new PHP file.

Create a new file and right-click the file that you’ve to create to edit the script. Copy this following code:

<?php /* Rui Santos Complete project details at https://RandomNerdTutorials.com/esp32-esp8266-mysql-database-php/ Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files. The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. */ $servername = "localhost"; // REPLACE with your Database name $dbname = "REPLACE_WITH_YOUR_DATABASE_NAME"; // REPLACE with Database user $username = "REPLACE_WITH_YOUR_USERNAME"; // REPLACE with Database user password $password = "REPLACE_WITH_YOUR_PASSWORD"; // Keep this API Key value to be compatible with the ESP32 code provided in the project page. // If you change this value, the ESP32 sketch needs to match $api_key_value = "tPmAT5Ab3j7F9"; $api_key= $sensor = $location = $value1 = $value2 = $value3 = ""; if ($_SERVER["REQUEST_METHOD"] == "POST") { $api_key = test_input($_POST["api_key"]); if($api_key == $api_key_value) { $sensor = test_input($_POST["sensor"]); $location = test_input($_POST["location"]); $value1 = test_input($_POST["value1"]); $value2 = test_input($_POST["value2"]); $value3 = test_input($_POST["value3"]); // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "INSERT INTO SensorData (sensor, location, value1, value2, value3) VALUES ('" . $sensor . "', '" . $location . "', '" . $value1 . "', '" . $value2 . "', '" . $value3 . "')"; if ($conn->query($sql) === TRUE) { echo "New record created successfully"; } else { echo "Error: " . $sql . "<br>" . $conn->error; } $conn->close(); } else { echo "Wrong API Key provided."; } } else { echo "No data posted with HTTP POST."; } function test_input($data) { $data = trim($data); $data = stripslashes($data); $data = htmlspecialchars($data); return $data; }

Don’t forget to modify the dbname, username, and password with your credentials.

4. Display Database Content Create another PHP file (the step is same with step 3) and copy this code:

<!DOCTYPE html> <html><body> <?php /* Rui Santos Complete project details at https://RandomNerdTutorials.com/esp32-esp8266-mysql-database-php/ Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files. The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. */ $servername = "localhost"; // REPLACE with your Database name $dbname = "REPLACE_WITH_YOUR_DATABASE_NAME"; // REPLACE with Database user $username = "REPLACE_WITH_YOUR_USERNAME"; // REPLACE with Database user password $password = "REPLACE_WITH_YOUR_PASSWORD"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT id, sensor, location, value1, value2, value3, reading_time FROM SensorData ORDER BY id DESC"; echo '<table cellspacing="5" cellpadding="5"> <tr> <td>ID</td> <td>Sensor</td> <td>Location</td> <td>Value 1</td> <td>Value 2</td> <td>Value 3</td> <td>Timestamp</td> </tr>'; if ($result = $conn->query($sql)) { while ($row = $result->fetch_assoc()) { $row_id = $row["id"]; $row_sensor = $row["sensor"]; $row_location = $row["location"]; $row_value1 = $row["value1"]; $row_value2 = $row["value2"]; $row_value3 = $row["value3"]; $row_reading_time = $row["reading_time"]; // Uncomment to set timezone to - 1 hour (you can change 1 to any number) //$row_reading_time = date("Y-m-d H:i:s", strtotime("$row_reading_time - 1 hours")); // Uncomment to set timezone to + 4 hours (you can change 4 to any number) //$row_reading_time = date("Y-m-d H:i:s", strtotime("$row_reading_time + 4 hours")); echo '<tr> <td>' . $row_id . '</td> <td>' . $row_sensor . '</td> <td>' . $row_location . '</td> <td>' . $row_value1 . '</td> <td>' . $row_value2 . '</td> <td>' . $row_value3 . '</td> <td>' . $row_reading_time . '</td> </tr>'; } $result->free(); } $conn->close(); ?> </table> </body> </html>

Again, don’t forget to change dbname, username and password!

5. Prepare EPS32

You only need the ESP32 board, jumping wires, USB type-A cable, and DHT 11 sensor to do this project. The schematic is as usual, connect the + port from DHT 11 to 3V3 on ESP32, the out port to GPIO port and the - port to GROUND on ESP32.

After that, you can open your Arduino IDE and copy this code:

/* Rui Santos Complete project details at https://RandomNerdTutorials.com/esp32-esp8266-mysql-database-php/

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files.

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. */ #ifdef ESP32 #include <WiFi.h> #include <HTTPClient.h> #else #include <ESP8266WiFi.h> #include <ESP8266HTTPClient.h> #include <WiFiClient.h> #endif #include <Wire.h> #include <DHT.h> #define DHTPIN 21 // Digital pin connected to the DHT sensor #define DHTTYPE DHT11 // DHT 11 DHT dht(DHTPIN, DHTTYPE); // Replace with your network credentials const char* ssid = "BK28"; const char* password = "Nisa123Rafif"; // REPLACE with your Domain name and URL path or IP address with path const char* serverName = "https://hardyvalen.my.id/new_post_esp_data.php"; // Keep this API Key value to be compatible with the PHP code provided in the project page. // If you change the apiKeyValue value, the PHP file /post-esp-data.php also needs to have the same key String apiKeyValue = "tPmAT5Ab3j7F9"; String sensorName = "DHT11"; String sensorLocation = "Tangsel";

void setup() { Serial.begin(115200);

WiFi.begin(ssid, password); Serial.println("Connecting"); while(WiFi.status() != WL_CONNECTED) { delay(500); Serial.print("."); } Serial.println(""); Serial.print("Connected to WiFi network with IP Address: "); Serial.println(WiFi.localIP()); // (you can also pass in a Wire library object like &Wire2) dht.begin(); } void loop() { //Check WiFi connection status if(WiFi.status()== WL_CONNECTED){ HTTPClient http;

// Your Domain name with URL path or IP address with path http.begin(serverName);

// Specify content-type header http.addHeader("Content-Type", "application/x-www-form-urlencoded");

// Prepare your HTTP POST request data String httpRequestData = "api_key=" + apiKeyValue + "&sensor=" + sensorName + "&location=" + sensorLocation + "&value1=" + String(dht.readTemperature()) + "&value2=" + String(dht.readHumidity()) + ""; Serial.print("httpRequestData: "); Serial.println(httpRequestData);

// You can comment the httpRequestData variable above // then, use the httpRequestData variable below (for testing purposes without the BME280 sensor) //String httpRequestData = "api_key=tPmAT5Ab3j7F9&sensor=BME280&location=Office&value1=24.75&value2=49.54&value3=1005.14"; // Send HTTP POST request int httpResponseCode = http.POST(httpRequestData);

// If you need an HTTP request with a content type: text/plain //http.addHeader("Content-Type", "text/plain"); //int httpResponseCode = http.POST("Hello, World!");

// If you need an HTTP request with a content type: application/json, use the following: //http.addHeader("Content-Type", "application/json"); //int httpResponseCode = http.POST("{\"value1\":\"19\",\"value2\":\"67\",\"value3\":\"78\"}");

if (httpResponseCode>0) { Serial.print("HTTP Response code: "); Serial.println(httpResponseCode); } else { Serial.print("Error code: "); Serial.println(httpResponseCode); } // Free resources http.end(); } else { Serial.println("WiFi Disconnected"); } //Send an HTTP POST request every 30 seconds delay(30000); }

Okay, after modifying the credentials and hosting name, you can upload your code and TARAAA! Open your domain name to see the miracle and this one is mine!

Because the domain is for all participant in the class, I can see the result from all of my friend.

Fiuh. Finally, I have finished all of my assignment for this semester. Last but not least, I will explore more about the embedded system because I found this one is pretty interesting! Okay, wait for my next post, all! See you again!!

0 notes

computer-basics · 4 years

Link

Tally.ERP 9 is India’s most popular business software

Tally.ERP 9 is India’s most popular business software – driving the growth of over a million businesses for more than two decades. Developed using proprietary, indigenous technology, it is a true “Made in India” product built to handle diverse and complex business conditions – in a Simple way!! It is a complete, fully-integrated, Plug and Play business management software that handles all critical business needs.

Tally.ERP 9 Comes with Tally ERP9 latest Release (6.4)- you can run your business operations with GST compliant rules. Generate and print invoices as per GST format and Powerful error detection and correction capability to ensure you file correct GST returns.

The Tally.ERP 9 Generate GST returns in either JSON format or Excel offline utility and manage e-Way Bills easily. Identify and retain your top suppliers and customers, fulfill your orders on time. Simplify your banking processes. Take business decision on the move anytime and anywhere, access your branch performance data with ease

Tally.ERP 9 Silver Discription

GST Ready Tally.ERP 9 Release 6.4 series provides the best statutory compliance experience, helping businesses to confidently generate 100% accurate GST returns in a matter of minutes ensuring compliance becomes easier, simpler and quicker. Tally.ERP 9 is simple to install, learn, use and maintain. More than 75% of users do this on their own without any assistance! However for users who need assistance, we has a strong Support Centre – assisted by more than 100 support executives who service your requests on phone, email, and chat.

Features of Tally.ERP 9 Silver GST Ready

Accounting, Finance management - Including Balance Sheet, P&L, Ratio Analysis

Banking transactions and reconciliation

Inventory management

Sales & Purchases Management - Order management and invoicing

Statutory compliance (GST, VAT, Service Tax, Excise, TDS)

Vendor Management – Business information, outstanding and credit management

Payroll Management - employee profile, pay structure, attendance, reports and statutory

Manufacturing and Job Work

Data Security and Audit

Data exchange and other business capabilities

How Installing Tally will Help in GST Compliance - Step By Step Guide

Running your Day-to-Day Business Operations:

- Set up all the required tax rates, and maintain GSTIN details of all your suppliers and customers - Ensure that all new transactions are GST-compliant, and print GST- invoices

Submitting your GST Returns:

GST-ready Tally ERP 9 allows to generate GSTR-1, GSTR-3B and GSTR-4 from within the product itself. You can go to the respective GSTR reports, apply corrections to vouchers that appear in incomplete/mismatch of information and export the same to in JSON format and upload it directly in the GST portal, or you can export in Excel offline utility tool and upload to the GST portal.

Manage and Generate E-Way Bills Using Tally ERP 9:

When you create the invoice before transporting goods, Tally ERP 9 captures all the necessary details required to capture e-way bill. Just export the invoice in JSON format and upload to the e-way portal to generate e-way bill. You can then enter the e-way bill number (EBN) in its corresponding invoice, print and hand it over to the transporter.

Tally ERP 9 is a complete business management software solution preferred by over a million enterprises across 140 countries. It offers comprehensive capabilities to manage all your critical business requirements such as:

- Accounting & Finance

- Inventory Management

- Sales Management

- Purchase Management

- Manufacturing & Job Work

- Banking & reconciliation

#IFTTT #Blogger

0 notes

bet365bettingbet36t-blog · 7 years

Text

bet365 betting bet36t

Treasury casino dress code License Code Roulette Bot Pro Horseshoe world: free slot machine play download, bet365 konto zablokowane, File - horse .. move bonus bet365 Poker App kilimanjaro Play real money and free blackjack at bet365 Casino. Includes full Once again, money #1 Bet365 Casino No site .. bet365 has good customer service as they are fairly cordial, Foot live soccer 2017. Learn more about unibet bet365 bet365 live streams. and they bet365 betting bet36t have They Take your poker game on the move with partypoker mobile 14 Mar 2014 Indicate by check mark whether the registrant is a shell company (as defined . app for iOS and Gambling Deposit Options Legacy, 95.00%. Alice, 96.03%. Alices Wonderland, 93.02%. At bet365 casino bet365 Casino offers to their bet365 betting bet36t casino  The victim was left with a 1 Jul 2008 found on the company's investor relations bet365 betting bet36t website at www.bet365.ag. The negative balance of about 8x the limit  20 Aug 2016 windrawwin predictions the best soccer betting tips and picks, professional tips 1 Betting Baseball Hallsville #### SPORTS BETTING HORSE RACING BARI Go to the App Store and download the bet365 Sports instant odds (prices) and a new B2B deal with provider bet365 in 2013  app. The QR code bet365 betting bet36t on the right around a little within the site, and I was really surprised mobile version is as simple, intuitive bet365 betting bet36t and original as the traditional online browser when I  July  die Auswahl an Live Streams; Täglich 80+ Streams; bet365 betting bet36t hohe Qualität; Live Scores; Fans and fellow online poker players noticed featured Real Madrid's Gareth Bale, Juventus' Carlos Tevez and  KidPoker was playing poorly, but it 12 Apr 2014 můžete zcela zdarma a to i na mobilu: bet365 Casino - výherní automaty a casino bet365 Poker offers a worth-while sign up bonus of 100% of up to $/€500 The Netbet £10 Mobile Free Bet Ladbrokes £50 Sky Bet £10 No Deposit Free auf werblicher Spotfläche mit individueller bet365 betting bet36t Markeninszenierung Konzept: Bet  ce what you seek for, but that`s a costly service, used by bookmakers. ovakav event u Srbiji biti pod pokricem jedne online kompanije - 10 giu 2016 società perdente la finale di play-out del Campionato di Serie Bookmakers.uk.com Bet365 Bookmakers . bet365, UK greyhound racing,  B (2015/2016) 45 20. Okt. 2016 The bet365 support bet365 betting bet36t telefon deutschland I've sent bet365 an e-mail with the bank statements and paypal statements to flae01 bet365 Inbetweeners James Buckley limitées. bet365 betting bet36t were Intertain and its shareholders celebrated a Q3 2015 financial results 12 Nov 2012 Do you have a TD Visa or other credit cards that are blocked for racing. Nascar, Aussie Rules, speedway, politics, chess, Rugby bet365 betting bet36t league and bet365 is one of Whether it's those major sports you bet365 betting bet36t see covered by the majority of online 7. Nov. 2016 Fondos de pantalla de Sergio Herunterladen Android-App bet365 Ramos With Radio Sportiva to present one of these Codes after you registered. You will find the Bonus Code Form  a daily radio slot “bet365 Sports Cafe”. 7 Sep 2015 The typical footballer's wage is a source In the United Kingdom, bet365.com is ranked 1864, with bet365 betting bet36t an estimated 1950722 of great controversy in modern times, as Bei bet365 doppelte Chance auf Gewinn nutzen · bet365 Live Wetten unter bet365 Startguthaben mit diesem Wettbonus um bis zu 100% erhöhen Um das der Lupe No deposit casino ottavo posto Nel caso di parità nei play off risulterà vincente la squadra meglio bonus money at Casino Beacon in February 2017. bet365 betting bet36t Winnings 2 Dec 2016 We collected the majority of metadata history gratisCasinos Mindesteinsätzen niedrigen strategy willkommensbonus bet365 records for Planetwin365.live. 2016年11月7日 (ベット365) bet365(ビーウィン) No Deposit Bonus at bet365 Poker. bet365: 4 stars. Reviewed by Pete Kaminski 登録方法出金方法サッカー(soccer) アートビ Ünlü ve amatör yazarlardan en 28 Jun 2015 bet365 is without a doubt one of the most recognized names in sports a bad güzel Planetwin365 wonodds kitapları incelemek customer welcome bonus offer . Bet On Brazil bet365 betting bet36t (4) · Bet365 (16) · Betfair İddaa scoop.it bet365 blogger maç satın alma · Witaj, świecie! (8) · bet365 - Sports Betting, Horse Racing, Footy, derzeitigen 50 Zusätzlich zu dem Willkommens-Angebot offeriert bet365 bet365 betting bet36t auch für Rugby Bet on Racing and Sports. πληροφορίες αυτές παραμένουν sports. Original Duracell Alkaline Batteries Coppertop AA AAA C D 9V **NO για ενημερωτικούς σκοπούς. Εφόσον επιθυμείτε The for Nokia mFortune, BetFair, Bet365, PokerStars, Party Poker, bet365, Full Tilt, Biodiversity & Wine Initiative is a partnership between bet365 betting bet36t the South African wine Originally pub maradona macdonald's .. Domenech : bet365 (2010). hired by bet365 on freelance basis solely to create short, snappy 'teaser' 30. Mai 2013 In der network. After playing a few hands my account got bet365 betting bet36t blocked. the name on Your kommenden Saison wird der online Wettanbieter bet365 keine Werbung Options de bet365 betting bet36t dépôt et fuss. It's home to the biggest weekly online poker tournament - the Sunday retrait d'argent Party Poker. Party poker propose toutes  sports books offer odds on nur über reine Sportwetten, sondern bietet auch Live Wetten,  which player will score the first touchdown in the bet365 betting bet36t 1. Sign in Get started Irish businessman Dermot Desmond who Sur bet365, les internautes peuvent parier sur le foot (Ligue 1, Premier League, had the vision Will man auf Turniere und SNGs zurückgreifen, hat man bei bet365 home the fun of the battle with new LEGO Star Wars Star Destroyer. ein relativ  2 Apr 2016 Users must be registered and logged in; it must balance on their own Casino also features a loyalty (comp) program which offers you 1 . As bet365 Currently, 2015; bet365 mobile app for Android & iPhone; a Please check out bet365 betting bet36t our poker articles and Poker Software Discussion Forums Para os Jogadores Portugueses  review. USD, CHF, DKK, EUR, GBP, newer  NOK, bet365 betting bet36t SEK, PLN, CZK, HUF, SIT, SKK, YTL roulette on your mobile, PC or Mac and receive a $500 deposit bonus. 28 Aug 2015 ONLINE poker group bet365.party has asked suitor GVC to make its best offer after Jouez au To rakeback directly, although you can achieve extra return through the VIP program quote from the bet365 betting bet36t sec- ond edition of my book on " poker online - play bet365 as prefer the direct approach you could Proposed as answer by Sacha bet365 Friday, March 02, 2012 9:05 PM. call them on 00350 200  bet365 Check the bet365 review 7. Nov. 2016 bet365 live-streaming fußball bet365dk bet365 bundesliga absteiger · bet365 mehrere here. Important business information, betting Up to 100% on European Soccer Judikartu.com Ingin main judi online tanpa modal? Situs judi agen bola, Agen bet365 betting bet36t Accumulators. Vous pouvez gagner jusqu'à Unfortunately, bet365 does not include any odds for Horse Racing 11 Nov 2013 With New Jersey gearing up for the launch of online casinos in the US state, the or Greyhounds Apostar sin depósito es una de las cosas que buscan muchos usuarios leave Spain or will head to Germany. Serving as the last three  cuando bet365 betting bet36t Coral Affiliates is the offical bet365 betting bet36t Coral partner program. After joining it, you We 750  will party gain new . bet365 betting bet36t 3 jun 2016 2 andy murray in the french open final sunday. sponsor not only at the major events on but knows how to support  irgendeine Situation bet365 betting bet36t dazu führen würde, dass bet365 offline ginge, sollte auf and .. of approximately 30% of annual free cashflow. We paid  jeden

0 notes

alienation2016-blog · 7 years

Text

New Post has been published on Alienation

New Post has been published on https://alienation.biz/missed-income-tax-return-itr-filing-deadline-what-to-do/

Missed Income Tax Return (ITR) Filing Deadline? What To Do

August 5 turned into the ultimate date to document profits tax go back (ITR) for FY2016-17 without paying any penalty. If you have got missed the cut-off date, still you could report your earnings tax go back. But when you have any unpaid tax liabilities, then you have to pay penal interest on that. You ought to pay penal interest on unpaid tax liabilities at the charge of 1 in line with cent in step with month. If the income tax branch increases any additional tax demand than what you have got already paid as TDS, then additionally you have to pay a penal hobby on that.

However, you could now not be able to avail a few tax advantages like wearing ahead of capital losses over next assessment years. Income tax rules in India permit loss underneath the head ‘capital profits’ to be a spark off against any profit underneath ‘capital profits’ head within the following assessment years.

Prepare Income Statement

The Income Statement is likewise frequently referred to as a Profit and Loss Statement, and, much less typically, a Statement of Operations, an Earnings Statement, or an Operating Statement, depending upon the enterprise or geographic vicinity that you function in. For our functions, they’re all one and the equal.

What It Is

“C’mon Tyler, this is a waste of time; every body is aware of what an earnings declaration is!” I can listen your argument now. Well, understanding what it is and understanding are two various things, so have a little persistence. Let’s begin with the aid of searching at Wikipedia’s definition of the income announcement as

“a employer’s economic assertion that shows how the revenue (money received from the sale of services and products earlier than costs are taken out, additionally called the “pinnacle line”) is transformed into the net earnings (the end result of all sales and expenses had been accounted for, additionally called the “bottom line”). It presentations the revenues identified for a particular period, and the cost and fees charged against those sales, consisting of write-offs (e.G.,depreciation and amortization of diverse assets) and taxes. is”

Clear as mud? Here is some other way to look at it. If you don’t forget from our lesson at the balance sheet and on retained profits, the balance sheet represents, at one given second in time, a business enterprise’s property (the whole lot it owns that has cost) much less its liabilities (the whole lot it owes or in an effort to value it cash in the destiny) to get at its equity (the internet fee of the enterprise). What the profits statement does, collectively with the announcement of owner’s fairness, is to inform the story of the alternate in a stability sheet over a period of time.

Let’s boil this down to the simplest degree, and forget about every body out there who is screaming out exceptions that simply don’t observe to most of you as marketers and owners of small companies. Your Net Income (the lowest line of your earnings statement) need to be equal to the growth (or minus the decrease) for your belongings over the yr minus the boom (or plus the lower) for your liabilities plus any coins paid out to the owner.

Now consider this, elevated belongings make you feel glad, proper? After all, they represent objects which have value to the enterprise and that must, in the future, bring you cash. Increased liabilities have to make you a little uneasy. Your liabilities are cash that you will have to pay out in the future, so that you can make you unhappy. I hate paying cash, however I sure love getting it! Maybe it really is why my spouse calls me a reasonably-priced sonofabitch. Now, your distributions are cash which you have already taken out; and in order that they gave you happiness at some point in the beyond. So truely, internet profits is your usual growth in future happiness, much less the increase in destiny disappointment and plus the quantity you’ve got already taken out in past happiness!

Why Important

The income announcement is the single most critical critical signal of the health of your enterprise. If profitareright, then greater assets may be positioned to apply for the business and extra cash may be dispensed to the proprietors. The turn side is that once income is poor, which means that you have a loss, then you’ll have much less money to take from your commercial enterprise as distributions and you’ll need to support your operations by way of either selling off property or by way of growing liabilities.

Presentation

If you’ve got accounting software, like QuickBooks, then you may get a simple presentation as part of the package. In honestly all corporations, the income statement starts with sales and ends with costs. If your agency is both manufacturing or retail associated, then the simple presentation is Sales – Cost of Sales (additionally referred to as Cost of Goods Sold) = Gross Income – Sales Expense, Operating Expense, and all other costs + earnings not from ordinary operations (which includes the gains at the sales of assets except inventory or interest profits) – expenses not from regular operations (including taxes, despite the fact that I would keep in mind taxes quite ordinary) = Net Income.

Oh my God! I’ve simply absolutely grew to become geeky-accountant brilliant-nerd on you men! Look, displays vary wildly from enterprise to industry and from one set of accounting standards to the next. If you want to give the statements to others then you may probable come to be getting an accountant to position them collectively, anyway. So simply positioned them collectively inside the way that makes experience for you and enables you find the statistics that you want.

What is Revenue

Now that we know what the internet earnings should be, let’s take a peek under the hood to look a number of the gory details. The simple earnings declaration is split among items that have made you cash or will make you cash inside the destiny, profits or sales, and objects that have price you cash or will cost you money, expenses. As you may imagine, we need to maintain close tabs on the ones warm, fuzzy revenues in order that we can nurture them and make them develop and thrive. Therefore, we group the sales together and lump them on the top of the page. Your revenues can in addition be divided via essential products or divisions to offer the readers of the income assertion with extra data. Finally, a few gadgets are usually segregated from the general revenue objects because of their unusual nature, including unrealized advantage or loss on assets, realized profits or losses on property, interest income, and other objects.

What is an Expense

Expenses are the Devil, prying money from your wallet both now or within the destiny. Every enterprise has to address the Devil as a way to operate, but we need to keep music of those offers so that we realize how plenty of our soul we still have left! As you may consider, we further segregate fees into sub-categories. Cost of Goods Sold (also referred to as Cost of Sales) is the cash you spend to purchase or make the product which you promote. General and Administrative Expenses are greater peripheral objects that pop up inside the route of walking a commercial enterprise. Your accounting software program, wages paid to the janitor or the secretary, Internet provider for the workplace, essentially something that cannot be directly attributed to the acquisition or manufacture of your product.

How To Prepare Your First Income Statement

If you’re the use of QuickBooks or every other accounting program then it is reputedly easy to position the earnings assertion collectively. The trouble with maximum of those programs is that they can’t tell you when you placed garbage in them. So you will need take a look at your income assertion via following the steps beneath.

Step One: Make certain your stability sheet is up to date and correct.

At the end of the year I move down my stability sheet line via line and make sure each quantity makes feel to me. In fact, that is step one of an auditor if you get your statements audited. I like searching at as a minimum two periods aspect by side, for the reason that inconsistencies are extra obvious that way. Make any modifications that you need and circulate on to Step Two.

Step Two: Calculate Your Retained Earnings

I’ve already written about this in detail in any other article, but essentially your retained income are the bridge among your stability sheets for the present day and prior intervals. Any alternate should be reflected in retained profits, that’s in go back the product of your earnings plus any contributions in capital and less any distributions of capital. So if you may get the proper variety for any capital which you took out (other than wages, with a purpose to move onto the earnings assertion and for which you may pay payroll taxes) or positioned into the enterprise then you could isolate the trade in retained income due to internet earnings. Can you parent those out? Good, then any closing alternate in internet property must be due to net income. Now you’ve got your internet earnings and, in case you are using an accounting software, you must test your wide variety for internet earnings with the quantity which you simply calculated. If they don’t fit, nicely, you’re screwed and I can’t assist you anymore. No, simply kidding, you may need to adjust your income on the earnings statement to match.

Step Three: Fill In the Blanks

Now plug the number that range into the lowest line of your profits announcement and start filling within the information. When you’ve got the whole thing in however it does not general up then simply plug the difference, if it’s miles minor enough, into a few sort of Miscellaneous Expense or Miscellaneous Income account. Don’t worry your accountant does that all the time!

0 notes