neetpiq

My two cents about software development on the web


By

Mongo Import type information

source: MongoDB Manual 2.6.4

JSON can only represent a subset of the types supported by BSON. To preserve type information, mongoimport accepts strict mode representation for certain types.

For example, to preserve type information for BSON types data_date and data_numberlong during mongoimport, the data should be in strict mode representation, as in the following:

{ "_id" : 1, "volume" : { "$numberLong" : "2980000" }, "date" : { "$date" : "2014-03-13T13:47:42.483-0400" } }

For the data_numberlong type, mongoimport converts into a float during the import.

By

Troubleshooting SQL Server: A Guide for the Accidental DBA

troubleshooting-sqlserver

Three SQL Server MVPs provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than “papering over the cracks”.

[green_box]Free PDF download[/green_box]

Source: Red Gate book store – Troubleshooting SQL Server: A Guide for the Accidental DBA.

By

Why Database Technology Matters

Because I think database technologies are among the most important fundamental advancements of humanity and our collective consciousness. I think databases are as important as telecommunications and the internet. I think they are as important as any scholarly library — and that libraries are the earliest non-digital databases. I think databases are almost as important the invention of the written word.

Forget SQL. Forget network, document or object databases. Forget the relational algebra. Forget schemas. Forget joins and normalization. Forget ACID. Forget map/reduce.

Think knowledge representation. Think knowledge collection, transformation, aggregation, sharing. Think knowledge discovery.

Think of humanity and its collective mind expanding.

sourceWhy Database Technology Matters

By

Importance of testing with large data sets

It’s sometimes hard or impossible to get suitable large data set that represents real data for your product. That’s why it’s important that already when you are learning a new technology you train your skills with large data sets. This way you will learn the performance and concurrency challenges when running your own throwaway training programs where it’s easier to find sample data rather than later building the product for a company.

[..]

Plan your first application in a way that you can run large data sets through it. Even if it’s purpose is for you to just learn the technology. Nowadays there are so many easy to use libraries for accessing xml-files, data-files, databases, etc. that it will not add much effort on your application development to support importing large sets of data. And learning to import data is surely a skill that you’ll need later.

source: Importance of testing with large data sets

By

SQLite and .NET

Usefull links utili about SQLite and .NET:

  • SQLite Home Page – SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
  • System.Data.SQLite – An open source ADO.NET provider for the SQLite database engine. System.Data.SQLite is the original SQLite database engine and a complete ADO.NET 2.0/3.5 provider all rolled into a single mixed mode assembly. It is a complete drop-in replacement for the original sqlite3.dll (you can even rename it to sqlite3.dll if you’re using it natively).
  • SQLite Database Browser is a freeware, public domain, open source visual tool used to create, design and edit database files compatible with SQLite. It is meant to be used for users and developers that want to create databases, edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands.
  • DbLinq – DbLinq is THE LINQ provider that allows to use common databases with an API close to Linq to SQL. It currently supports (by order of appearance): MySQL, Oracle, PostgreSQL, SQLite, Ingres, Firebird… And still SQL Server.
  • SQLite Administrator – it is a powerful tool if you easily want to create, design or administrate SQLite database files. The SQL code editor helps you to quickly write sql queries with features such as code completion and highlighting. Both major versions of SQLite database files are supported by SQLite Administrator.
  • Getting started with SQLite and .NET – SQLite is a “self-contained, serverless, zero-configuration, transactional SQL database engine.” It is utilized in a few systems you may have heard of: Firefox, Skype, iPhone, and Android to name a few. The entire database is stored in a single file, which means your application or website can utilize a fully functional relational database without the constraints or costs of a traditional database server.