SQLiteOnline Reviews

db<>fiddle Reviews

SQLiteOnline mentions (7)

• SQL: What Percent of Each Group of People Owns Bicycles?

  - Note: I found this online website to try the SQL code https://sqliteonline.com/. Source: almost 1 year ago

• Isar vs SQFLite

  6) SQlite is a real database (i.e.: it's ACID, it has SQL support (which IS A MUST - use the right tool for the right job)). There are tons of documentation and help availble online an you can even create your database on a page and test SQL against it: https://sqliteonline.com/. Source: about 1 year ago

• can someone verify some code for me, job interview?

  I had errors on certain sql but I was able to get this to run on https://sqliteonline.com/. Source: about 1 year ago

• Extracted tables from Statement of Financial Affairs, CSV download

  SQLite database, download, unzip, and use database tool e.g https://sqliteonline.com/ to query the database. Some python scripts included too. Https://drive.google.com/file/d/1PtTFgpN8ZOKXfpmpSQKYHiYpYTCpS4yl/view?usp=sharing. Source: over 1 year ago

• Can you check if I'm doing these queries right and are they correctly optimized (if that's required)

  (at the end I added the table information I'm playing with - I tested these on sqliteonline.com). Source: almost 2 years ago

db<>fiddle mentions (19)

• How to display the total hours and actual hours of the employee as the time spent in office when there are work from home and work from office entry for same day?

  Also, reducing your problem down to a minimal reproducible example, along with some sample data (and ideally a http://sqlfiddle.com/ or https://dbfiddle.uk/ link) will get you much better answers. Source: about 1 year ago

• Virtual Northwinds database?

  Http://dbfiddle.uk has an AdventureWorks test DB that you could use. Source: about 1 year ago

• I want one query to reference another .... not sure whether to do "USE" "INSERT" or what else

  If you used https://dbfiddle.uk to create a table, load it up with a minimum set of representative rows, then created a minimal, yet representative "first query" and then mocked up what you want your "second query"'s output to look like based on the example data, it might be way easier to comprehend what you are talking about. Source: over 1 year ago

• Order By expression value then column value

  Put it in a fiddle, like dbfiddle.uk or sqlfiddle.com. Source: over 1 year ago

• Show HN: Postgres WASM

  I don't mean to take anything away from this post - its quite amazing and I can't wait to play with it more - but wanted to mention that there are sites out there that I believe solve the training portion maybe a little bit better, at least if all you want is to train on SQL not DBA type actions. My favorite is https://dbfiddle.uk/ - the ability to link and fork a set of statements is extremely handy. - Source: Hacker News / over 1 year ago