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 »
