• Computers

Using SQLite

Small. Fast. Reliable. Choose Any Three.
Author: Jay A. Kreibich
Publisher: "O'Reilly Media, Inc."
ISBN: 9781449399641
Category: Computers
Page: 530
View: 4883
Application developers, take note: databases aren't just for the IS group any more. You can build database-backed applications for the desktop, Web, embedded systems, or operating systems without linking to heavy-duty client-server databases such as Oracle and MySQL. This book shows you how to use SQLite, a small and lightweight relational database engine that you can build directly into your application. With SQLite, you'll discover how to develop a database-backed application that remains manageable in size and complexity. This book guides you every step of the way. You'll get a crash course in data modeling, become familiar with SQLite's dialect of the SQL database language, and much more. Learn how to maintain localized storage in a single file that requires no configuration Build your own SQLite library or use a precompiled distribution in your application Get a primer on SQL, and learn how to use several language functions and extensions Work with SQLite using a scripting language or a C-based language such as C# or Objective-C Understand the basics of database design, and learn how to transfer what you already know to SQLite Take advantage of virtual tables and modules "Complex SQL concepts explained clearly." --D. Richard Hipp, creator of SQLite

    • Computers

The Definitive Guide to SQLite


Author: Grant Allen,Mike Owens
Publisher: Apress
ISBN: 1430232269
Category: Computers
Page: 368
View: 7607
Outside of the world of enterprise computing, there is one database that enables a huge range of software and hardware to flex relational database capabilities, without the baggage and cost of traditional database management systems. That database is SQLite—an embeddable database with an amazingly small footprint, yet able to handle databases of enormous size. SQLite comes equipped with an array of powerful features available through a host of programming and development environments. It is supported by languages such as C, Java, Perl, PHP, Python, Ruby, TCL, and more. The Definitive Guide to SQLite, Second Edition is devoted to complete coverage of the latest version of this powerful database. It offers a thorough overview of SQLite’s capabilities and APIs. The book also uses SQLite as the basis for helping newcomers make their first foray into database development. In only a short time you can be writing programs as diverse as a server-side browser plug-in or the next great iPhone or Android application! Learn about SQLite extensions for C, Java, Perl, PHP, Python, Ruby, and Tcl. Get solid coverage of SQLite internals. Explore developing iOS (iPhone) and Android applications with SQLite. SQLite is the solution chosen for thousands of products around the world, from mobile phones and GPS devices to set-top boxes and web browsers. You almost certainly use SQLite every day without even realizing it!

    • Computers

SQLite


Author: Chris Newman
Publisher: Sams Publishing
ISBN: N.A
Category: Computers
Page: 313
View: 1760
SQLite is a small, fast, embeddable database. What makes it popular is the combination of the database engine and interface into a single library as well as the ability to store all the data in a single file. Its functionality lies between MySQL and PostgreSQL, however it is faster than both databases. In SQLite, author Chris Newman provides a thorough, practical guide to using, administering and programming this up-and-coming database. If you want to learn about SQLite or about its use in conjunction with PHP this is the book for you.

    • Computers

Getting Started with SQL

A Hands-On Approach for Beginners
Author: Thomas Nield
Publisher: "O'Reilly Media, Inc."
ISBN: 1491938560
Category: Computers
Page: 134
View: 1372
Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you’re a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases. Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you’ll also discover how to efficiently design and manage databases to meet your needs. You’ll also learn how to: Explore relational databases, including lightweight and centralized models Use SQLite and SQLiteStudio to create lightweight databases in minutes Query and transform data in meaningful ways by using SELECT, WHERE, GROUP BY, and ORDER BY Join tables to get a more complete view of your business data Build your own tables and centralized databases by using normalized design principles Manage data by learning how to INSERT, DELETE, and UPDATE records

    • Computers

Data Wrangling with Python

Tips and Tools to Make Your Life Easier
Author: Jacqueline Kazil,Katharine Jarmul
Publisher: "O'Reilly Media, Inc."
ISBN: 1491948779
Category: Computers
Page: 508
View: 5450
How do you take your data analysis skills beyond Excel to the next level? By learning just enough Python to get stuff done. This hands-on guide shows non-programmers like you how to process information that’s initially too messy or difficult to access. You don't need to know a thing about the Python programming language to get started. Through various step-by-step exercises, you’ll learn how to acquire, clean, analyze, and present data efficiently. You’ll also discover how to automate your data process, schedule file- editing and clean-up tasks, process larger datasets, and create compelling stories with data you obtain. Quickly learn basic Python syntax, data types, and language concepts Work with both machine-readable and human-consumable data Scrape websites and APIs to find a bounty of useful information Clean and format data to eliminate duplicates and errors in your datasets Learn when to standardize data and when to test and script data cleanup Explore and analyze your datasets with new Python libraries and techniques Use Python solutions to automate your entire data-wrangling process

    • Computers

MySQL Reference Manual

Documentation from the Source
Author: Michael Widenius,David Axmark,MySQL AB
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596002657
Category: Computers
Page: 802
View: 3646
This comprehensive reference guide offers useful pointers for advanced use of SQL and describes the bugs and workarounds involved in compiling MySQL for every system.

    • BUSINESS & ECONOMICS

Data Science from Scratch

First Principles with Python
Author: Joel Grus
Publisher: "O'Reilly Media, Inc."
ISBN: 1491904402
Category: BUSINESS & ECONOMICS
Page: 330
View: 5940
Data science libraries, frameworks, modules, and toolkits are great for doing data science, but they’re also a good way to dive into the discipline without actually understanding data science. In this book, you’ll learn how many of the most fundamental data science tools and algorithms work by implementing them from scratch. If you have an aptitude for mathematics and some programming skills, author Joel Grus will help you get comfortable with the math and statistics at the core of data science, and with hacking skills you need to get started as a data scientist. Today’s messy glut of data holds answers to questions no one’s even thought to ask. This book provides you with the know-how to dig those answers out. Get a crash course in Python Learn the basics of linear algebra, statistics, and probability—and understand how and when they're used in data science Collect, explore, clean, munge, and manipulate data Dive into the fundamentals of machine learning Implement models such as k-nearest Neighbors, Naive Bayes, linear and logistic regression, decision trees, neural networks, and clustering Explore recommender systems, natural language processing, network analysis, MapReduce, and databases

    • Computers

Information Modelling and Knowledge Bases XXVII


Author: T. Welzer,H. Jaakkola,B. Thalheim
Publisher: IOS Press
ISBN: 1614996113
Category: Computers
Page: 364
View: 8573
Information modeling has become an increasingly important topic for researchers, designers and users of information systems. In the course of the last three decades, information modeling and knowledge bases have become essential, not only with regard to information systems and computer science in an academic context, but also with the use of information technology for business purposes. This book presents 29 papers selected and upgraded from those delivered at the 25th International Conference on Information Modelling and Knowledge Bases (EJC 2015), held in Maribor, Slovenia, in June 2015. The aim of the conference is to bring together experts from different areas of computer science and other disciplines, including philosophy and logic, cognitive science, knowledge management, linguistics, and management science, with a view to understanding and solving problems and applying research results to practice. Areas covered by the papers include: conceptual modeling; knowledge and information modeling and discovery; linguistic modeling; cross-cultural communication and social computing; environmental modeling and engineering; and multimedia data modeling and systems. The book will be of interest to all those whose work involves the development or use of information modeling and knowledge bases.

    • Computers

Python3.3.4 Tkinter/Ttk Widgets and Sqlite3

For Windows and Debian-linux Includes Source Code
Author: Herb Norbom
Publisher: CreateSpace
ISBN: 9781500906962
Category: Computers
Page: 110
View: 5028
Fantastic book for working with Python 3.3, Tkinter/Ttk and Sqlite3. Rich examples are provided that give the reader the knowledge to use the GUI features of Python. The book is directed at the GUI Tkinter/Ttk and the use of the Sqlite3 database. The Tkinker/Ttk widgets have the ability to use Style and Themes for greatly enhancing your programs visual qualities. With the map feature you can quickly tie your visual representation to the actions of the user. Each example has a discussion section that goes into some depth on the features. A complete Python source code of the example is provided. If you are just getting started with Python's GUI you will find answers to many of your questions. If you are advanced you will find this book to be great desktop reference. The examples are written in as simple as possible Python code so that the reader can grasp the concepts of the "widget" or process. If you want to get your feet wet with Sqlite3 this book is a great starting point. Examples are provided that get your database up and running quickly. You will be amazed at how rapidly you grasp the Sqlite3 process. Of course examples are provided that use Tkinter/Ttk and Sqlite3 together. With the many standard features available in Python enhanced with the GUI and database your programs will become quite sophisticated.

    • Computers

MongoDB: The Definitive Guide


Author: Kristina Chodorow,Michael Dirolf
Publisher: "O'Reilly Media, Inc."
ISBN: 9781449396985
Category: Computers
Page: 216
View: 2151
How does MongoDB help you manage a huMONGOus amount of data collected through your web application? With this authoritative introduction, you'll learn the many advantages of using document-oriented databases, and discover why MongoDB is a reliable, high-performance system that allows for almost infinite horizontal scalability. Written by engineers from 10gen, the company that develops and supports this open source database, MongoDB: The Definitive Guide provides guidance for database developers, advanced configuration for system administrators, and an overview of the concepts and use cases for other people on your project. Learn how easy it is to handle data as self-contained JSON-style documents, rather than as records in a relational database. Explore ways that document-oriented storage will work for your project Learn how MongoDB’s schema-free data model handles documents, collections, and multiple databases Execute basic write operations, and create complex queries to find data with any criteria Use indexes, aggregation tools, and other advanced query techniques Learn about monitoring, security and authentication, backup and repair, and more Set up master-slave and automatic failover replication in MongoDB Use sharding to scale MongoDB horizontally, and learn how it impacts applications Get example applications written in Java, PHP, Python, and Ruby

    • Computers

SQL Cookbook


Author: Anthony Molinaro
Publisher: "O'Reilly Media, Inc."
ISBN: 0596009763
Category: Computers
Page: 595
View: 1453
A guide to SQL covers such topics as retrieving records, metadata queries, working with strings, data arithmetic, date manipulation, reporting and warehousing, and hierarchical queries.

    • Computers

MySQL for Python


Author: Albert Lukaszewski,Antony Reynolds
Publisher: Packt Publishing Ltd
ISBN: 1849510199
Category: Computers
Page: 441
View: 8672
This is a practical, tutorial-style book that includes many examples to demonstrate the full potential of MySQL for Python. Every chapter starts with an explanation of the various areas for using MySQL for Python and ends with work on a sample application using the programming calls just learned. All complicated concepts are broken down to be very easy to understand. Everything in the book is designed to help you learn and use MySQL for Python to address your programming needs in the fastest way possible. This book is meant for intermediate users of Python who want hassle-free access to their MySQL database through Python. If you are a Python programmer who wants database-support in your Python applications, then this book is for you. This book is a must-read for every focused user of the MySQL for Python library who wants real-world applications using this powerful combination of Python and MySQL.

    • Computers

Learning SQL

Master SQL Fundamentals
Author: Alan Beaulieu
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596555580
Category: Computers
Page: 338
View: 707
Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will: Move quickly through SQL basics and learn several advanced features Use SQL data statements to generate, manipulate, and retrieve data Create database objects, such as tables, indexes, and constraints, using SQL schema statements Learn how data sets interact with queries, and understand the importance of subqueries Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.

    • Database management

Inside SQLite


Author: Sibsankar Haldar
Publisher: "O'Reilly Media, Inc."
ISBN: 0596550065
Category: Database management
Page: N.A
View: 1590

    • Political Science

Analyzing Political Communication with Digital Trace Data

The Role of Twitter Messages in Social Science Research
Author: Andreas Jungherr
Publisher: Springer
ISBN: 3319203193
Category: Political Science
Page: 220
View: 6759
This book offers a framework for the analysis of political communication in election campaigns based on digital trace data that documents political behavior, interests and opinions. The author investigates the data-generating processes leading users to interact with digital services in politically relevant contexts. These interactions produce digital traces, which in turn can be analyzed to draw inferences on political events or the phenomena that give rise to them. Various factors mediate the image of political reality emerging from digital trace data, such as the users of digital services’ political interests, attitudes or attention to politics. In order to arrive at valid inferences about the political reality on the basis of digital trace data, these mediating factors have to be accounted for. The author presents this interpretative framework in a detailed analysis of Twitter messages referring to politics in the context of the 2009 federal elections in Germany. This book will appeal to scholars interested in the field of political communication, as well as practitioners active in the political arena.

    • COMPUTERS

Programming PHP


Author: Kevin Tatroe,Peter MacIntyre,Rasmus Lerdorf
Publisher: "O'Reilly Media, Inc."
ISBN: 1449365841
Category: COMPUTERS
Page: 540
View: 9634
This updated edition teaches everything you need to know to create effective web applications with the latest features in PHP 5.x. You’ll start with the big picture and then dive into language syntax, programming techniques, and other details, using examples that illustrate both correct usage and common idioms. If you have a working knowledge of HTML, the authors’ many style tips and practical programming advice will help you become a top-notch PHP programmer. Get an overview of what’s possible with PHP programs Learn language fundamentals, including data types, variables, operators, and flow control statements Understand functions, strings, arrays, and objects Apply common web application techniques, such as form processing, data validation, session tracking, and cookies Interact with relational databases like MySQL or NoSQL databases such as MongoDB Generate dynamic images, create PDF files, and parse XML files Learn secure scripts, error handling, performance tuning, and other advanced topics Get a quick reference to PHP core functions and standard extensions

    • Computers

Python Cookbook


Author: Alex Martelli,Anna Ravenscroft,David Ascher
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596554743
Category: Computers
Page: 846
View: 6215
Portable, powerful, and a breeze to use, Python is the popular open source object-oriented programming language used for both standalone programs and scripting applications. It is now being used by an increasing number of major organizations, including NASA and Google.Updated for Python 2.4, The Python Cookbook, 2nd Edition offers a wealth of useful code for all Python programmers, not just advanced practitioners. Like its predecessor, the new edition provides solutions to problems that Python programmers face everyday.It now includes over 200 recipes that range from simple tasks, such as working with dictionaries and list comprehensions, to complex tasks, such as monitoring a network and building a templating system. This revised version also includes new chapters on topics such as time, money, and metaprogramming.Here's a list of additional topics covered: Manipulating text Searching and sorting Working with files and the filesystem Object-oriented programming Dealing with threads and processes System administration Interacting with databases Creating user interfaces Network and web programming Processing XML Distributed programming Debugging and testing Another advantage of The Python Cookbook, 2nd Edition is its trio of authors--three well-known Python programming experts, who are highly visible on email lists and in newsgroups, and speak often at Python conferences.With scores of practical examples and pertinent background information, The Python Cookbook, 2nd Edition is the one source you need if you're looking to build efficient, flexible, scalable, and well-integrated systems.

    • Computers

Android SQLite Essentials


Author: Sunny Kumar Aditya,Vikash Kumar Karn
Publisher: Packt Publishing Ltd
ISBN: 1783282967
Category: Computers
Page: 110
View: 4528
This is an ideal book for Android programmers who want to explore SQLite databases based on Android applications. The general competency level expected of the reader is prior knowledge of developing applications and basic knowledge of Android and SQL.

    • Computers

OS X Yosemite: The Missing Manual


Author: David Pogue
Publisher: "O'Reilly Media, Inc."
ISBN: 1491948523
Category: Computers
Page: 878
View: 2517
With Yosemite, Apple has unleashed the most innovative version of OS X yet—and once again, David Pogue brings his expertise and humor to the #1 bestselling Mac book. Mac OS X 10.10 includes more innovations from the iPad and adds a variety of new features throughout the operating system. This updated edition covers it all with something new on practically every page. Get the scoop on Yosemite’s big-ticket changes Learn enhancements to existing applications, such as Safari and Mail Take advantage of shortcuts and undocumented tricks Use power user tips for networking, file sharing, and building your own services