Such databases offer option to create consistent backup during runtime, usually by calling special command. Fully agree. There is for sure a better way to snapshot the SQLite database. Meanwhile I dump my important data to InfluxDB in parallel so that one has become more important. Good work! Ended with an empty file.

Thanks for this, will give it a go. I see in my case the problem is in the events table — is there any way to only recreate the events table and keep the rest? Delete all from the events table? or drop table and recreate? This worked perfectly — thanks! That´s not necessarily because of loosing data, but possibly due to the former version not been repacked for some time. db from scratch - almost empty.

What a shocking moment. Option 2 is still the hard way. Ah yes, by the way: Option 1 was the path I went. Fast lane. Energy dashboard only calculates once a hour so it took until the next full hour to create the next hour graph.

By the way, for me there are only two possible ways to go in terms of database because as my HA grew I really really REALLY need to make sure my database is safe and backed up reliably - I did mention it, did I? Maybe I can automate one of these backups to run it regularly to reduce HA downtime by running a physical backup.

Will have a look at what I will get and if consistency is fine. Sounds promising anyway:. Was away for 3 days an when I came back I releazied the history just ends yesterday and did run a. on the corrupted db. The process it self looked successful and the db was shrinking from 4. When starting ha core with the new fixed db file it just got detected as corrupted again. So I bite the bitter apple and restored a db file from my last backup a week ago. First I was pleased as I could browse the energy statistics again while ha core was starting up with the db from the backup but as time ha was completely started indicated on the web front down left with a message the database from the backup was again detected as corrupted and the energy statistics I just browsed seconds ago are gone.

I feel you. They are working on it, but it might take months they finally fix this - after years. Short: forget the database backups. If the recover process did not work for you there might be no other option. Maybe… run some offline consistency checks after the. recover, quick check, full check and foreign key check. By the way: looks like your database is trying to upgrade.

Did you update HA meanwhile? So are you trying to use a database from a former HA release with a newer HA? I would try to have HA Core and DB at the same date. Unlucky me all database get recognized as corrupt.

Latest log spitted out this:. Could you drop me 3 lines how exactly to do this? Only thing I did till no is to have the sqlite3 recover thing running for a couple of times. Additionally, last year, homes where the head of household was out of work were nearly five times more likely to not have a bank account as compared to those where the household head was employed.

Recession predictions Is a recession inevitable in ? Here's what experts are saying. Add Topic. Charisse Jones USA TODAY. Battle against predatory lending: Mississippi social justice firm fights payday 'predatory lending' in low-income communities Checks arrived late for some of the unbanked: For 'unbanked' Americans, pandemic stimulus checks arrived slowly and with higher fees. What does it mean to be unbanked? Who are the underbanked? So different people are going to have different decisions.

And that's not just true for crypto, but also other areas of the law. Your best-known crypto decisions strongly assert that crypto is traceable. One way people try to make it less traceable is with mixers, and Tornado Cash was sanctioned by OFAC not too long ago.

Do you think the legal reasoning was sound enough for similar sanctions to be applied to other mixers, or decentralized exchanges?

I don't know. I think there's been some discussion that people may litigate some of these things, so I can't comment, because those frequently do come to our courthouse. And I think there are certainly people opining on that, yes and no. So much of what judges do is that we rely on the parties that are before us to tell us what's right and what's wrong.

And then, you know, obviously, they'll have different views, and we make a decision based on what people say in front of us. Are you aware that some legal analysis of the Tornado Cash sanctions references your recent decision in a cryptocurrency sanctions case? That's what good lawyers will always do. Even legislators might look at that as they try to think about where the gaps are.

As a prosecutor I had a case where we sued three Chinese banks to give us their bank records, and it had never been done before. Afterwards, Congress passed a new law, using the decisions from judges in this court and the D. circuit court, the court above us. So I'm sure people look at prior decisions and try to apply them in the ways that they want to. Are there any misconceptions about how the law applies to crypto, or how your decisions should be interpreted, that you wish you could get across?

One misconception is that the judges can't understand this technology — we can. People have these views in two extremes. The lawyer's fundamental job is to take super complex and technical things and boil them down to very easily digestible arguments for a judge, for a jury, or whoever it might be. The financial technology transformation is driving competition, creating consumer choice, and shaping the future of finance. Hear from seven fintech leaders who are reshaping the future of finance, and join the inaugural Financial Technology Association Fintech Summit to learn more.

Financial technology is breaking down barriers to financial services and delivering value to consumers, small businesses, and the economy. Fintech puts American consumers at the center of their finances and helps them manage their money responsibly. From payment apps to budgeting and investing tools and alternative credit options, fintech makes it easier for consumers to pay for their purchases and build better financial habits.

Fintech also arms small businesses with the financial tools for success, including low-cost banking services, digital accounting services, and expanded access to capital. We advocate for modernized financial policies and regulations that allow fintech innovation to drive competition in the economy and expand consumer choice. Spots are still available for this hybrid event, and you can RSVP here to save your seat. Join us as we discuss how to shape the future of finance. In its broadest sense, Open Banking has created a secure and connected ecosystem that has led to an explosion of new and innovative solutions that benefit the customer, rapidly revolutionizing not just the banking industry but the way all companies do business.

Target benefits are delivered through speed, transparency, and security, and their impact can be seen across a diverse range of use cases. Sharing financial data across providers can enable a customer individual or business to have real-time access to multiple bank accounts across multiple institutions all in one platform, saving time and helping consumers get a more accurate picture of their own finances before taking on debt, providing a more reliable indication than most lending guidelines currently do.

Companies can also create carefully refined marketing profiles and therefore, finely tune their services to the specific need. Open Banking platforms like Klarna Kosma also provide a unique opportunity for businesses to overlay additional tools that add real value for users and deepen their customer relationships.

The increased transparency brought about by Open Banking brings a vast array of additional benefits, such as helping fraud detection companies better monitor customer accounts and identify problems much earlier.

The list of new value-add solutions continues to grow. The speed of business has never been faster than it is today. For small business owners, time is at a premium as they are wearing multiple hats every day. Macroeconomic challenges like inflation and supply chain issues are making successful money and cash flow management even more challenging. This presents a tremendous opportunity that innovation in fintech can solve by speeding up money movement, increasing access to capital, and making it easier to manage business operations in a central place.

Fintech offers innovative products and services where outdated practices and processes offer limited options. For example, fintech is enabling increased access to capital for business owners from diverse and varying backgrounds by leveraging alternative data to evaluate creditworthiness and risk models. This can positively impact all types of business owners, but especially those underserved by traditional financial service models. When we look across the Intuit QuickBooks platform and the overall fintech ecosystem, we see a variety of innovations fueled by AI and data science that are helping small businesses succeed.

By efficiently embedding and connecting financial services like banking, payments, and lending to help small businesses, we can reinvent how SMBs get paid and enable greater access to the vital funds they need at critical points in their journey.

Overall, we see fintech as empowering people who have been left behind by antiquated financial systems, giving them real-time insights, tips, and tools they need to turn their financial dreams into a reality. Innovations in payments and financial technologies have helped transform daily life for millions of people. People who are unbanked often rely on more expensive alternative financial products AFPs such as payday loans, money orders, and other expensive credit facilities that typically charge higher fees and interest rates, making it more likely that people have to dip into their savings to stay afloat.

A few examples include:. Mobile wallets - The unbanked may not have traditional bank accounts but can have verified mobile wallet accounts for shopping and bill payments. Their mobile wallet identity can be used to open a virtual bank account for secure and convenient online banking. Minimal to no-fee banking services - Fintech companies typically have much lower acquisition and operating costs than traditional financial institutions.

They are then able to pass on these savings in the form of no-fee or no-minimum-balance products to their customers. This enables immigrants and other populations that may be underbanked to move up the credit lifecycle to get additional forms of credit such as auto, home and education loans, etc.

Entrepreneurs from every background, in every part of the world, should be empowered to start and scale global businesses.

Most businesses still face daunting challenges with very basic matters. These are still very manually intensive processes, and they are barriers to entrepreneurship in the form of paperwork, PDFs, faxes, and forms.

Stripe is working to solve these rather mundane and boring challenges, almost always with an application programming interface that simplifies complex processes into a few clicks. Stripe powers nearly half a million businesses in rural America. The internet economy is just beginning to make a real difference for businesses of all sizes in all kinds of places. We are excited about this future. The way we make decisions on credit should be fair and inclusive and done in a way that takes into account a greater picture of a person.

Lenders can better serve their borrowers with more data and better math. Zest AI has successfully built a compliant, consistent, and equitable AI-automated underwriting technology that lenders can utilize to help make their credit decisions. While artificial intelligence AI systems have been a tool historically used by sophisticated investors to maximize their returns, newer and more advanced AI systems will be the key innovation to democratize access to financial systems in the future.

D espite privacy, ethics, and bias issues that remain to be resolved with AI systems, the good news is that as large r datasets become progressively easier to interconnect, AI and related natural language processing NLP technology innovations are increasingly able to equalize access.

T he even better news is that this democratization is taking multiple forms. AI can be used to provide risk assessments necessary to bank those under-served or denied access. AI systems can also retrieve troves of data not used in traditional credit reports, including personal cash flow, payment applications usage, on-time utility payments, and other data buried within large datasets, to create fair and more accurate risk assessments essential to obtain credit and other financial services.

By expanding credit availability to historically underserved communities, AI enables them to gain credit and build wealth. Additionally, personalized portfolio management will become available to more people with the implementation and advancement of AI. Sophisticated financial advice and routine oversight, typically reserved for traditional investors, will allow individuals, including marginalized and low-income people, to maximize the value of their financial portfolios.

Moreover, when coupled with NLP technologies, even greater democratization can result as inexperienced investors can interact with AI systems in plain English, while providing an easier interface to financial markets than existing execution tools. Open finance technology enables millions of people to use the apps and services that they rely on to manage their financial lives — from overdraft protection, to money management, investing for retirement, or building credit.

More than 8 in 10 Americans are now using digital finance tools powered by open finance. This is because consumers see something they like or want — a new choice, more options, or lower costs.

What is open finance? At its core, it is about putting consumers in control of their own data and allowing them to use it to get a better deal. When people can easily switch to another company and bring their financial history with them, that presents real competition to legacy services and forces everyone to improve, with positive results for consumers.

For example, we see the impact this is having on large players being forced to drop overdraft fees or to compete to deliver products consumers want. We see the benefits of open finance first hand at Plaid, as we support thousands of companies, from the biggest fintechs, to startups, to large and small banks. All are building products that depend on one thing - consumers' ability to securely share their data to use different services.

Open finance has supported more inclusive, competitive financial systems for consumers and small businesses in the U. and across the globe — and there is room to do much more. As an example, the National Consumer Law Consumer recently put out a new report that looked at consumers providing access to their bank account data so their rent payments could inform their mortgage underwriting and help build credit.

This is part of the promise of open finance. At Plaid, we believe a consumer should have a right to their own data, and agency over that data, no matter where it sits. This will be essential to securing benefits of open finance for consumers for many years to come.

As AWS preps for its annual re:Invent conference, Adam Selipsky talks product strategy, support for hybrid environments, and the value of the cloud in uncertain economic times. Donna Goodison dgoodison is Protocol's senior reporter focusing on enterprise infrastructure technology, from the 'Big 3' cloud computing providers to data centers.

She previously covered the public cloud at CRN after 15 years as a business reporter for the Boston Herald. AWS is gearing up for re:Invent, its annual cloud computing conference where announcements this year are expected to focus on its end-to-end data strategy and delivering new industry-specific services. Both prongs of that are important. But cost-cutting is a reality for many customers given the worldwide economic turmoil, and AWS has seen an increase in customers looking to control their cloud spending.

By the way, they should be doing that all the time. The motivation's just a little bit higher in the current economic situation.

This interview has been edited and condensed for clarity. Besides the sheer growth of AWS, what do you think has changed the most while you were at Tableau? Were you surprised by anything? The number of customers who are now deeply deployed on AWS, deployed in the cloud, in a way that's fundamental to their business and fundamental to their success surprised me.

There was a time years ago where there were not that many enterprise CEOs who were well-versed in the cloud. It's not just about deploying technology. The conversation that I most end up having with CEOs is about organizational transformation. It is about how they can put data at the center of their decision-making in a way that most organizations have never actually done in their history.

And it's about using the cloud to innovate more quickly and to drive speed into their organizations. Those are cultural characteristics, not technology characteristics, and those have organizational implications about how they organize and what teams they need to have. It turns out that while the technology is sophisticated, deploying the technology is arguably the lesser challenge compared with how do you mold and shape the organization to best take advantage of all the benefits that the cloud is providing.

How has your experience at Tableau affected AWS and how you think about putting your stamp on AWS? I, personally, have just spent almost five years deeply immersed in the world of data and analytics and business intelligence, and hopefully I learned something during that time about those topics. I'm able to bring back a real insider's view, if you will, about where that world is heading — data, analytics, databases, machine learning, and how all those things come together, and how you really need to view what's happening with data as an end-to-end story.

It's not about having a point solution for a database or an analytic service, it's really about understanding the flow of data from when it comes into your organization all the way through the other end, where people are collaborating and sharing and making decisions based on that data.

AWS has tremendous resources devoted in all these areas. Can you talk about the intersection of data and machine learning and how you see that playing out in the next couple of years? What we're seeing is three areas really coming together: You've got databases, analytics capabilities, and machine learning, and it's sort of like a Venn diagram with a partial overlap of those three circles.

There are areas of each which are arguably still independent from each other, but there's a very large and a very powerful intersection of the three — to the point where we've actually organized inside of AWS around that and have a single leader for all of those areas to really help bring those together.

There's so much data in the world, and the amount of it continues to explode. We were saying that five years ago, and it's even more true today. The rate of growth is only accelerating. It's a huge opportunity and a huge problem.

A lot of people are drowning in their data and don't know how to use it to make decisions. Other organizations have figured out how to use these very powerful technologies to really gain insights rapidly from their data. What we're really trying to do is to look at that end-to-end journey of data and to build really compelling, powerful capabilities and services at each stop in that data journey and then…knit all that together with strong concepts like governance.

A footnote in Microsoft's submission opens in new tab to the UK's Competition and Markets Authority CMA has let slip the reason behind Call of Duty's absence from the Xbox Game Pass library: Sony and Activision Blizzard have a deal that restricts the games' presence on the service. The footnote appears in a section detailing the potential benefits to consumers from Microsoft's point of view of the Activision Blizzard catalogue coming to Game Pass.

What existing contractual obligations are those? Why, ones like the "agreement between Activision Blizzard and Sony," that places "restrictions on the ability of Activision Blizzard to place COD titles on Game Pass for a number of years". It was apparently these kinds of agreements that Xbox's Phil Spencer had in mind opens in new tab when he spoke to Sony bosses in January and confirmed Microsoft's "intent to honor all existing agreements upon acquisition of Activision Blizzard".

Unfortunately, the footnote ends there, so there's not much in the way of detail about what these restrictions are or how long they'd remain in effect in a potential post-acquisition world. Given COD's continued non-appearance on Game Pass, you've got to imagine the restrictions are fairly significant if they're not an outright block on COD coming to the service.

Either way, the simple fact that Microsoft is apparently willing to maintain any restrictions on its own ability to put first-party games on Game Pass is rather remarkable, given that making Game Pass more appealing is one of the reasons for its acquisition spree.

The irony of Sony making deals like this one while fretting about COD's future on PlayStation probably isn't lost on Microsoft's lawyers, which is no doubt part of why they brought it up to the CMA. While it's absolutely reasonable to worry about a world in which more and more properties are concentrated in the hands of singular, giant megacorps, it does look a bit odd if you're complaining about losing access to games while stopping them from joining competing services.

We'll find out if the CMA agrees when it completes its in-depth, "Phase 2" investigation opens in new tab into the Activision Blizzard acquisition, which is some way off yet. For now, we'll have to content ourselves with poring over these kinds of corporate submissions for more interesting tidbits like this one. So far, we've already learned that Microsoft privately has a gloomy forecast for the future of cloud gaming opens in new tab , and that the company thinks Sony shouldn't worry so much since, hey, future COD games might be as underwhelming as Vanguard opens in new tab.

Who knows what we'll learn next? Sign up to get the best content of the week, and great gaming deals, as picked by the editors. One of Josh's first memories is of playing Quake 2 on the family computer when he was much too young to be doing that, and he's been irreparably game-brained ever since. His writing has been featured in Vice, Fanbyte, and the Financial Times.

He'll play pretty much anything, and has written far too much on everything from visual novels to Assassin's Creed. His most profound loves are for CRPGs, immersive sims, and any game whose ambition outstrips its budget. He thinks you're all far too mean about Deus Ex: Invisible War. Open menu Close menu PC Gamer PC Gamer THE GLOBAL AUTHORITY ON PC GAMES. opens in new tab opens in new tab opens in new tab opens in new tab opens in new tab opens in new tab.

US Edition. News Reviews Hardware Best Of Magazine The Top Forum More PCGaming Show Podcasts Coupons Newsletter SignUp Community Guidelines Affiliate Links Meet the team About PC Gamer. Popular WoW: Dragonflight Darktide Midnight Suns Holiday gifts Warzone 2. Audio player loading…. PC Gamer Newsletter Sign up to get the best content of the week, and great gaming deals, as picked by the editors.

Contact me with news and offers from other Future brands Receive email from us on behalf of our trusted partners or sponsors. Joshua Wolens. See comments.

db'" Maybe I can automate one of these backups to run it regularly to reduce HA downtime by running a physical backup. And it's about using the cloud to innovate more quickly and to drive speed into their organizations. Prior to joining Protocol in , he worked on the business desk at The New York Times, where he edited the DealBook newsletter and wrote Bits, the weekly tech newsletter. Good work! There is for sure a better way to snapshot the SQLite database.

Categories:

• Forex
• Forex Brokers
• Binary Options
• Binary Options online
• Forex Bitcoin