Browsed by
Category: Database

Comparison of databases for UWP apps: SQLite, Realm & LiteDB

Comparison of databases for UWP apps: SQLite, Realm & LiteDB

Object oriented ap­pli­ca­tions usu­ally needs ob­ject ori­ented stor­age. Re­la­tions are good at map­ping poin­t­ers but many tech­ni­cal lim­i­ta­tions are hid­den un­der doc­u­men­ta­tion crust. It is not easy to choose the right database tech­nol­ogy be­cause pros are writ­ten ev­ery­where and cons are spread across many GitHub is­sues. It is like buy­ing a new car. You know the price, power and fuel con­sump­tion but you must in­quire into re­li­a­bil­ity and main­te­nance costs. SQLite Im­pos­si­ble to re­name or re­move ex­ist­ing ta­ble col­umn. SQLite…

Read More Read More

LINQPad: build and test LINQ queries

LINQPad: build and test LINQ queries

LINQPad is not just for LINQ queries, but any C#/F#/VB expression, statement block or program. Put an end to those hundreds of Visual Studio Console projects cluttering your source folder and join the revolution of LINQPad scripters and incremental developers. LINQPad also supports all the LINQ APIs in the .NET Framework, including LINQ to XML, PLINQ, LINQ to SQL and Entity Framework. https://www.linqpad.net/

MongoDB Atlas and free tier from amazon

MongoDB Atlas and free tier from amazon

MongoDB Atlas is a cloud-hosted MongoDB service engineered and run by the same team that builds the database. It incorporates operational best practices we’ve learned from optimizing thousands of deployments across startups and the Fortune 100. Build on MongoDB Atlas with confidence, knowing you no longer need to worry about database management, setup and configuration, software patching, monitoring, backups, or operating a reliable, distributed database cluster. MongoDB Atlas Pricing MongoDB Atlas Pricing With MongoDB Atlas, straightforward hourly pricing ensures that…

Read More Read More

Announcing General Availability of MySQL 8.0

Announcing General Availability of MySQL 8.0

https://blogs.oracle.com/mysql/announcing-general-availability-of-mysql-80 Performance MySQL 8.0 is up to 2x faster than MySQL 5.7.  MySQL 8.0 comes with better performance for Read/Write workloads, IO bound workloads, and high contention “hot spot” workloads.

Oracle Data Pump (expdp, impdp) in Oracle Database 10g, 11g, 12c

Oracle Data Pump (expdp, impdp) in Oracle Database 10g, 11g, 12c

Schema Exports/Imports The OWNER parameter of exp has been replaced by the SCHEMAS parameter which is used to specify the schemas to be exported. The following is an example of the schema export and import syntax. expdp scott/[email protected] schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT.dmp logfile=expdpSCOTT.log impdp scott/[email protected] schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT.dmp logfile=impdpSCOTT.log source: https://oracle-base.com/articles/10g/oracle-data-pump-10g