 | Lars Fosdal on Security alarm provider Woonve… |
 | Thomas Mueller on Question got closed in May 202… |
 | Thaddy de Koning on Formulier voor bewindvoerders… |
| Thaddy de Koning on Formulier voor bewindvoerders… |
| Thaddy de Koning on Formulier voor bewindvoerders… |
Posted by jpluimers on 2023/06/22
Boy, I wonder what can go wrong with [Wayback/Archive] Yes, I can connect to a DB in CSS
Via: [Wayback/Archive] Kris on Twitter: “… “Yes, I can connect to a DB in CSS” Abusing houdini.how, and using a JS version of Sqlite, CSS can connect to a DB.” / Twitter
Related:
–jeroen
Posted in CSS, Database Development, Development, Software Development, SQLite, Web Development | Leave a Comment »
Posted by jpluimers on 2022/10/27
I knew there was JSFiddle for live playing around with JavaScript and more in your browser, so I wondered if there was a similar site for databases and SQL queries.
There are, so here are a few database fiddle sites: SQL playgrounds where you can live play with SQL queries (sometimes even without an underlying example database).
All via [Wayback/Archive.is] database fiddle – Google Search:
Posted in Conference Topics, Conferences, Database Development, DB2, Development, Event, Firebird, JavaScript/ECMAScript, JSFiddle, MariaDB, MySQL, OracleDB, PL/SQL, PostgreSQL, Scripting, Software Development, SQL, SQL Server, SQLite, T-SQL | Leave a Comment »
Posted by jpluimers on 2020/06/04
Old, but still an interesting read: [WayBack] Why Is SQLite Coded In C and [WayBack] Appropriate Uses For SQLite.
TL;DR: SQLite – mainly competing with fopen has few dependencies and uses C in a boring way. I think that’s good.
Via: [WayBack] Why Is SQLite Coded In C – ThisIsWhyICode – Google+
–jeroen
Posted in C, Database Development, Development, Software Development, SQLite | Leave a Comment »
Posted by jpluimers on 2019/10/30
I could not find any vendors/architectures have public database servers.
So there is no good way to go beyond SQLFiddle (of which I wrote before in SQL Fiddle | A tool for easy online testing and sharing of database problems and their solutions and David Rodriguez: a few nice posts on SQL (via: Google+)), that does not provide database access, but allows you to fire SQL statements onto these architectures:
I get the thing (it is very hard to secure an “over the internet” connection to a database server; do NOT do this: [WayBack] connectivity – Connect to SQL Server over Internet – Database Administrators Stack Exchange), so the alternative is to run locally.
If you run locally, there are plenty of example/demo database, like:
- download AdventureWorks-oltp-install-script.zip and extract the zip file to the C:\Samples\AdventureWorks folder.
- Open
C:\Samples\AdventureWorks\instawdb.sqlin SQL Server Management Studio and follow the instructions at the top of the file.
In step 2, do not forget to set the query window to SQLCMD syntax. Or just run the script using the [WayBack] sqlcmd Utility | Microsoft Docs (which reminds me I should update SQL Sever: batch files to find instances and sqlcmd.exe/osql.exe)
–jeroen
Posted in Database Development, Development, MySQL, OracleDB, PostgreSQL, SQL, SQL Server, SQLite | Leave a Comment »
The Wiert Corner - irregular stream of stuff 