⚙️Are you looking for an #online #database #modeling #tool with #SQL generation?
With the latest updates (e.g. modeling of #association #classes), BESSER is your ideal tool to #design and #generate your databases in many different "flavours" :
☑️ #SQLLite
☑️ #PostgresQL
☑️ #MySQL
☑️ #MariaDB
☑️ #MSSQLServer
☑️ and even #SQLAlchemy
Ready to give it a try? No installation required! ➡️ https://editor.besser-pearl.org/
Did I already mention is completely 🆓 and #opensource?
#Development #Techniques
Optimizing SQLite for servers · How to tweak an underestimated database engine https://ilo.im/15yfmc
_____
#Database #DatabaseEngine #SQL #SqlLite #Server #Hosting #Cloud #WebDev #Backend
SQLite the New Hotness?! SQLite is popping up in many places all of a sudden as hot new tech.
https://hackernoon.com/sqlite-the-new-hotness?source=rss&utm_medium=erik.in&utm_source=mastodon
The last year I have been working off and on building a race timing system.. Yesterday after nearly a year of work my app was the primary timing app for the rec leagues regional championship!!!
The system worked great and massively improved the whole experience. Including getting the awards ceremony done in a fraction of the time of previous years!!
Built in #GoLang #VueJS #SqlLite #WebPack #PWA #ProgressiveWebApp #OpenSource
2.) ✅❌Blind Boolean-based SQL injection: Attacker sends a series of ✅true or ❌false statements to extract data from the DB. Like a game of 20 questions, the attacker keeps sending queries that reveal new sensitive info depending on if a certain condition is true or false. Little by little, they get more and information about what is in the mysterious magic 🪄✨⬛️"Black Box" that is your SQL database.
#MariaDB #SQLLite #SQLserver #Oracle #query #Php #Python #webdevelopment #programming
Code Project: VLC Portable Playlist to Text Dump
It's kind of funny how one post can lead to another sometimes. This one is pretty basic but it also just shows a bit how useful I find knowing my way around computer systems to be. Yesterday I posted about my little annual music playlists. And as part of that, I wanted to actually post the playlist. I am pretty sure there is a fairly uni
https://bloggingintensifies.com/42971-2/
#ProgrammingProjects #Coding #Database #music #SQL #SQLLite
To the tech Fediverse: any recommendations for a single user, mastodon API compatible server, that had few dependencies and it’s reasonably simple to install? Don’t care about UI, just the server part :) #fediverse #mastodon #singleuser #csharp #nodejs #sqllite
Love it or hate it, the capabilities of your modern web browser continuously grow in strange and wild ways. The ability for web apps to work offline requires a persistent local storage solution and for many, IndexedDB is the only choice as it works across most browsers and provides a database-like interface. However, as [James Long] found, IndexedDB is painfully slow on chrome and limited in querying ability. He set out to bring a tool he was familiar with, SQLite, and bring it to the web browser as absurd-sql.
Why absurd? Partially because most browsers (not chrome) implement IndexedDB on top of SQLite. So for many browsers, it is just SQLite on top of IndexedDB on top of SQLite. Luckily for [James] there already was a project known as sql.js that uses emscripten to compile the C-based SQLite into WebAssembly. However, sql.js uses an in-memory storage backing and all data is lost when refreshing the page. [James] tweaked SQLite's method of reading and writing blocks. Instead of being memory backed, he added a layer to read and write blocks from IndexedDB. This means that only sections of the database need to be read in, bringing in huge performance gains.
That brings us to the other reason why it's absurd. On chrome (as well as Firefox), absurd-sql beats IndexedDB on almost every benchmark. A query like SELECT SUM(*) FROM kv led to stunning results.
So what's the downside? Other than a somewhat large WebAssembly file that needs to get downloaded (409KB) and cached, there really isn't. Of course, it's not all roses when it comes to web development. Native SQLite runs 2-3 times faster than absurd-sql, which demonstrates how slow IndexedDB really is.
There are other storage standards on the horizon for web browsers, but locking becomes an issue. SQLite expects synchronous reads and writes because it's just simple C. IndexedDB and other storage solutions are asynchronous as the event loop of Javascript lends itself well to that model. Absurd-sql gets around that by creating a SharedArrayBuffer that is shared with a worker process. The atomics API is used to communicate with the buffer. In particular, atomics.wait() allows the worker to block main thread execution until the read or write has finished. From the perspective of SQLite, the operations are synchronous. IndexedDB provides transactions so multiple connections can happen (for example multiple tabs open). Multiple readonly transactions can occur in parallel but only one readwrite transaction can be in flight.
Why not pull up your browser and start playing around with it? You're already doomed to learn WebAssembly anyway.
#softwaredevelopment #emscripten #indexeddb #sql #sqllite #web #webassembly #webdev #webdevelopment
Rewriting Krita's Resource System -- Developer Seminar https://share.tube/videos/watch/38a9a9bc-8752-4a6b-8a2a-3b8548b48c6a
